Discussion on answer by srutzky: Execution Plan is NOT using INDEX and uses Table Scan

Discussion on answer by srutzky: Exec

Imported from a comment discussion on http://dba.stackexchange.com/questions/136262/execution-plan-is-not-using-index-and-uses-table-scan/136267#136267
3370d ago – Rob Farley
18
3
This room is frozen.
Public: anyone may enter and talk

Explicit write access

Even when this room is read-only or their reputation is too low, these users will be able to talk in this room. Users with insufficient reputation to chat have been granted write access to this room by a chat moderator.