it's available in SE.
On 3/6/07, John Dunn <JDunn_at_sefas.com> wrote:
>
> 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
>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 06 2007 - 07:55:16 CST
