Home Forums SQL Server 2008 SQL Server 2008 - General Usage of built-in functions on columns ignores/excludes Indexes on that column RE: Usage of built-in functions on columns ignores/excludes Indexes on that column

  • I never said the index won't be used with non SARG-able predicates: I said it cannot be searched.

    SQL Server has no way to navigate the index b-tree structure to find the rows that match the predicate, so it has to SCAN the whole index to evaluate every single row. With SARG-able predicates, the index can be searched.

    -- Gianluca Sartori