Re: Optimize LIKE '%abc%' queries
Posted by:
Bob Field
Date: August 04, 2006 02:56PM
With that data, full-text indexing won't help either. Possibly as you were suggesting storing permutations of the data, but that breaks normalization and you don't know how many combinations might exists.
Subject
Views
Written By
Posted
15720
August 04, 2006 02:12PM
6908
August 04, 2006 02:30PM
6305
August 04, 2006 02:36PM
Re: Optimize LIKE '%abc%' queries
5883
August 04, 2006 02:56PM
6912
August 04, 2006 03:35PM
5431
August 10, 2006 12:41PM
4759
August 10, 2006 01:54PM
5591
August 10, 2006 04:12PM
4101
August 10, 2006 04:27PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.