John. I'd've moved to intermedia for this
On 3/5/07, John Dunn <JDunn_at_sefas.com> 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
Received on Mon Mar 05 2007 - 06:37:32 CST
