Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Indexing for LIKE selection

Re: Indexing for LIKE selection

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Mon, 5 Mar 2007 22:55:21 +0200
Message-ID: <6e49b6d00703051255u5b528bf3n589771427ec4c06f@mail.gmail.com>


> I'd like to add that there is possibility also search for 'blah%'
> using index. Of course '%blah%' remains as bad as before.

As one of our list members privately pointed out - I of course meant that there is possibility to search using index with leading wildcard i.e. '%blah'.

Thank you! - you know who you are :)

Gints Plivna
http://www.gplivna.eu

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 05 2007 - 14:55:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US