Re: wildcard search and full tablescans

From: StefanKapitza <skapitza_at_volcanomail.com>
Date: 11 Dec 2006 23:31:45 -0800
Message-ID: <1165908705.925425.188190@80g2000cwy.googlegroups.com>

wagen123_at_yahoo.com wrote:
> Oracle10g 10.2.0.1
>
> select * from <table_name> where <column_name> like '%abc%';
>
> does not use the index and does a full tablescan (guess this is the
> expected behaviour as per explain plan).
>
> Any suggestions as to how to use the index (index hint didn't help), IF
> possible or other alternatives.
>
> thanks

you could try

http://www.dominicgiles.com/technicalpapers.html

(the Article about Bitmap Index)

regards

s.kapitza Received on Tue Dec 12 2006 - 01:31:45 CST