Home Forums SQL Server 2008 T-SQL (SS2K8) Dynamic Filter and Order By RE: Dynamic Filter and Order By
PiMané
SSChampion
Points: 13965
More actions
October 3, 2012 at 8:55 am
#1544979
Sean Lange (10/3/2012)NO LIKE is not SARGable so you will get scans. It has to examine every row to determine if it is a match or not.
Sean Lange (10/3/2012)
So a LIKE 'M%' is better replaced with a >= 'M' AND < 'N'..