Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Mon Mar 05 2007 - 04:42:47 CST
![]() |
![]() |