How to avoid full table access

Hello,

is it possible to avoid a full table access when selecting records with Like and or.

Example:
select * from customers where nr like '1%' or name like 'A%'

both colums are indexes and analyzed. Oracle takes the indexes when searching for each value alone

Thank you
Thomas Received on Sat Dec 22 2007 - 11:03:01 CST