Hello,
I have an index comprising of the following columns
cust#
sales order
line item
order date
and the table has been analyzed . The adhoc query application
can issue a query on any combination of these columns (and in any order)
when i issue a like query i.e 'where sales order like '<some value>%''
and run an explain plan on it, the results indicate a full table scan.
why doesn't oracle use the index ? it already has an indexed set of
values to choose from.
Also, does this mean that i have to create an index for each combination
of predicates ?
please help
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Sat Aug 21 1999 - 16:02:38 CDT
