Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> index not used in LIKE 'aaa%'
I have a table with 5 million rows with cbo.
An nonunique index is defined on patient_acct. There are only 6 rows qualified for the selection and why index is not used for query 2.
select patient_acct,pi_surr_id from pymtitem where (PATIENT_ACCT like '613%3713HENSL').
thanks ted Received on Mon Apr 19 2004 - 11:56:11 CDT