Path: text.usenetserver.com!out03b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!80g2000cwy.googlegroups.com!not-for-mail
From: "StefanKapitza" <skapitza@volcanomail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: wildcard search and full tablescans
Date: 11 Dec 2006 23:31:45 -0800
Organization: http://groups.google.com
Lines: 24
Message-ID: <1165908705.925425.188190@80g2000cwy.googlegroups.com>
References: <1165492532.019079.313140@l12g2000cwl.googlegroups.com>
NNTP-Posting-Host: 212.255.50.136
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1165908712 9242 127.0.0.1 (12 Dec 2006 07:31:52 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 12 Dec 2006 07:31:52 +0000 (UTC)
In-Reply-To: <1165492532.019079.313140@l12g2000cwl.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2.1) Gecko/20030225,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: 80g2000cwy.googlegroups.com; posting-host=212.255.50.136;
   posting-account=S94O5QwAAACytf2Xn6iObGcxzaKP71O9
Xref: usenetserver.com comp.databases.oracle.server:418961
X-Received-Date: Tue, 12 Dec 2006 02:31:52 EST (text.usenetserver.com)


wagen123@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