Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Indexing for LIKE selection

Indexing for LIKE selection

From: John Dunn <JDunn_at_sefas.com>
Date: Mon, 5 Mar 2007 10:42:47 -0000
Message-ID: <2F802216565E44489600A03F763219A80BC5AD@mia.SEFASBRISTOL>


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
Received on Mon Mar 05 2007 - 04:42:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US