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: Remigiusz Soko?owski <rems_at_wp-sa.pl>
Date: Mon, 05 Mar 2007 13:34:24 +0100
Message-id: <45EC0E50.5040506@wp-sa.pl>


Stephane Faroult wrote:
>
> Same problem, by the way, with regular expressions. Needless to say,
> if the queries you expect are mostly of the '%blah%' kind, what you
> are performing is a text search, which points to Intermedia (or
> whatever it is called nowadays, it has been renamed half a score times
> at least since introduction).
>
>

of course You can also use external to database solution like Lucene at apache.org, which plays a similar role as Oracle Text searches

Regards
Remigiusz

-- 
---------------------------------------
Remigiusz Sokolowski <rems_at_wp-sa.pl>
WP/PTI/DIP/ZAB (+04858) 52 15 770

MySQL v04.x,05.x; Oracle v10.x
---------------------------------------

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 05 2007 - 06:34:24 CST

Original text of this message

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