This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Just when I think I understand Execution Plans a little, I have something like this.
For this Index Scan
The object shows that the index it's using is one that has the column RUN_TIME in it, only. No Includes. The output list is a bunch of columns on the table but not in that index. Where do they come from? I was sure that it would have to do a Key Lookup to get those.
A non-clustered index contains:
Your query apparently doesn't need any other columns, so the non-clustered index will cover the needs of the query and avoid the need for a key lookup to retrieve additional data.
See Nonclustered index architecture for details.
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Of course, the clustered index key columns. I'd forgotten about those. I blame age.