Re: LIKE performance

From: GreyBeard <Fuzzy.GreyBeard_at_gmail.com>
Date: Fri, 25 Feb 2005 01:56:56 GMT
Message-Id: <pan.2005.02.25.02.57.31.671299@gmail.com>

On Fri, 25 Feb 2005 10:21:13 +1000, lh wrote:

>
> I did experiment with substr as an index, but it doesn't seem to use the
> index after i add it. It just does a table scan.

Is the substr the only component in your where clause, or are there additional predicates?

I'd also recommend reading "Practical Oracle8i" by Jonathan Lewis and following some of the advice.

Finally, is there any way you could attempt a test with a more recent version, say 9iR2 or (pref) 10g? There have been a good number of advances that should help.

FGB Received on Thu Feb 24 2005 - 19:56:56 CST