Re: Indexing for LIKE selection

From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
To: JDunn@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 5 Mar 2007 12:37:32 +0000

John. I'd've moved to intermedia for this

On 3/5/07, John Dunn <JDunn@xxxxxxxxx> wrote:

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

Follow-Ups:

Re: Indexing for LIKE selection
From: Mladen Gogala

References:
- Indexing for LIKE selection
  - From: John Dunn

Other related posts:

Browse oracle-l