Re: Oracle 9.0.1.6 fails to use index with '=' but will with 'like'

From: Martin Weber <mweber_at_netbi.de>
Date: Thu, 2 Jun 2005 22:55:52 +0200
Message-ID: <429f7260$0$305$4d4ebb8e@read.news.de.uu.net>

Steven,
I guess it has something to do with optimizer strategy. LIKE is more expansive than =. This might cause the optimizer to use the Index for like and not for =.
Run a "analyze table coneventnp compute statistics for table for all indexes;" and check again.
Once you created any statistics on an object and are not using RULE optimizer goal, the query optimizer uses statistics at all. So you should create statistics for all objects and keep them up to date.

greetings
Martin

<steven.herod_at_gmail.com> schrieb im Newsbeitrag news:1116481176.689644.187540_at_g44g2000cwa.googlegroups.com...
> Sorry, I mean 9.2.06 is our version. Typo
>
Received on Thu Jun 02 2005 - 15:55:52 CDT