Re: Forcing use of an index

"Bob P" <bob_pombrio_at_yahoo.com> wrote in message news:1111071592.178952.243220_at_f14g2000cwb.googlegroups.com...
>I had a brain fart (working on too many different platforms at once), I
> saw CBO and thought of Common Business Objects.
>
> Yes we ae using the Cost Base optimizer.
>
> I don't have any choice on the query, it HAS to have the leading and
> trailing %'s because the data entry field that I am searching is a free
> form field that the users enter data into.

Can you change the query syntax, but not meaning? It sounds like a classic use for an OracleText index in which case your query would look like

select ...
from
where contains(col,:bindvar) > 0;

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com