Home Forums SQL Server 2008 T-SQL (SS2K8) Where clause prevents index seek RE: Where clause prevents index seek

  • December 1, 2015 at 10:06 am

    #1843264

    PHXHoward (12/1/2015)

    On its own, it is checking the table to see if there is a persisted computed column that has a NCI that matches the WHERE criteria. That's pretty great. I love SQL Server.

    Actually, it is looking for an index that it can use efficiently to accomplish the task. We provided that by creating a persisted computed column and creating an index on that column.