RE: Indexing for LIKE selection

Thanks for all the replies. It looks like Intermedia/Context/OracleText processing is the way to go.  

Is any of this supported by Standard Engine, or only Enterprise Edition in Oracle 8/9/10?    

John

From: John Dunn
Sent: 05 March 2007 10:43
To: oracle-l
Subject: Indexing for LIKE selection

We currently allow users to search a large table for a specific indexed value. Performance is fine.  

However they have now requested to be able to enter a partial string or wildcards.  

I am asssuming we will use the LIKE clause in the select statement.  

Do we need to review how we index the table? If so, what is most appropriate?  

Oracle version is 10.2  

John  

--
http://www.freelists.org/webpage/oracle-l