Home Forums SQL Server 2008 T-SQL (SS2K8) Dynamic Filter and Order By RE: Dynamic Filter and Order By

  • 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.

    So a LIKE 'M%' is better replaced with a >= 'M' AND < 'N'..


    If you need to work better, try working less...