Re: Index Not Used with Parameterized Query

Biff Gaut wrote:

> Thanks for the response - sorry for my slow reply, I purposefully left
> the computer home over the holidays!
>
> We are using Oracle 8i. All our queries use trailing '%', but none
> use a leading or embedded '%'.
>
> Biff Gaut
> Gaithersburg, MD

I take it you think every table access should be a full table scan.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)