Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Indexing for LIKE selection
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-lReceived on Mon Mar 05 2007 - 06:34:24 CST
![]() |
![]() |