Home Forums SQL Server 2008 T-SQL (SS2K8) Where clause prevents index seek RE: Where clause prevents index seek
PHXHoward
SSCrazy Eights
Points: 8388
More actions
December 1, 2015 at 9:55 am
#1843261
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.