Re: strategies for optimizing 'like' operations
Date: Fri, 7 Mar 2008 12:51:52 -0600
I'm not sure if these will work, but worth a shot: 1. Combination of a function-based index on UPPER(keyword) (if it doesn't already exist ) and using SYS_CONTEXT() to make the search look like a bind variable and possibly use the index. If seen like '%blah%' not use indexes but like 'blah%' will (selectivity?).
2. Not sure if the REGEXP could help in this case. WHERE REGEXP(UPPER(keyword),'regfexphere'). I haven't played around with how the optimizer treats this.Received on Fri Mar 07 2008 - 12:51:52 CST