SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using index in REGEXP_LIKE Search...

457000Aug 23 2006 — edited Aug 24 2006

Hi,

If I use LIKE operator as ' %<search_string>', then we can make use of the reverse index lookup. Similarly, if we use REGEXP_LIKE function for the same search above, then can we make use of any reverse indexing ?

Thanks & Regards,
Ayan

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 21 2006

Added on Aug 23 2006

13 comments

4,198 views