Re: Optimize LIKE '%abc%' queries
Posted by:
Bob Field
Date: August 04, 2006 02:30PM
If you are searching for a specific keyword in a list of keywords contained in that field, normalizing your data would help. Create a separate table containing a list of possible keywords, and a third table bridging the keyword list and the original table.
Subject
Views
Written By
Posted
15728
August 04, 2006 02:12PM
Re: Optimize LIKE '%abc%' queries
6914
August 04, 2006 02:30PM
6309
August 04, 2006 02:36PM
5886
August 04, 2006 02:56PM
6914
August 04, 2006 03:35PM
5434
August 10, 2006 12:41PM
4763
August 10, 2006 01:54PM
5596
August 10, 2006 04:12PM
4104
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.