RE: Indexing for LIKE selection
- From: "John Dunn" <JDunn@xxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 6 Mar 2007 11:42:57 -0000
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
Other related posts:
