RE: strategies for optimizing 'like' operations
Date: Sun, 9 Mar 2008 10:52:43 -0400
This idea depends on your data. In my situation it worked due to the layout of data and knowning the questions which would be asked. So it may not work for you.
In my case most of the data has some number of leading zeros and is always 16 bytes long. so I pre-figured the cardinality for the cases and placed it into the query using the cardinality hint. The predicates the users would leave off the leading zeros. This worked well for us.
A much more generic solution is to use Oracle Text, but of course that's not much good in an online system.
OxReceived on Sun Mar 09 2008 - 09:52:43 CDT