RE: Indexing for LIKE selection

From: John Dunn <JDunn_at_sefas.com>
Date: Tue, 6 Mar 2007 11:42:57 -0000
Message-ID: <2F802216565E44489600A03F763219A80BC5BA@mia.SEFASBRISTOL>

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

Received on Tue Mar 06 2007 - 05:42:57 CST