Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index Not Used with Parameterized Query
> I take it you think every table access should be a full table scan.
Just the opposite, I think the index on I.COL2 should be used. If I use no parameters or extend the query to use an additional search condition based on a second parameter then the index is used.
Biff Gaut
Gaithersburg, MD
Received on Tue Dec 30 2003 - 15:17:54 CST