Is a Index Scan always a Index Scan?
A few weeks ago, someone posted an interesting question on Twitter: Q: While watching a Summit14 recording, unanswered by speaker: Is there a way to tell how much of index is scanned with a NC scan operator? One of the answers to this question was that a Non-Clustered Index Scan scans always the whole index. …
