Optimizing LIKE in SQL statements

[Guest]

What can be done on the SQLServer end of things to optimize the speed of Fill
methods that use LIKE within the SQL statement.

 

[William \(Bill\) Vaughn]

Check out the Query Analyzer and see the query plan for the LIKE variations
you're executing. For example, if you code
".... WHERE x LIKE 'y%' "
the QO might find that an index can quickly locate the row. On the other
hand if you code:
".... WHERE x LIKE '%y' "
the QO must do a rowscan--the indexes can't help.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________