You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In the plan XML this appears as a "Clustered Index Seek", however it looks like this is for some sort of backwards compatibility reason. The lookup="true" attribute indicates that this is a Key Lookup. Documentation is here:
In SSMS, an operation that shows up as a "Key Lookup" in the plan, shows up in html-query-plan as a "Clustered Index Seek."
Here's an example plan:
https://www.brentozar.com/pastetheplan/?id=SJUjCeZkx
If you go to the XML tab, copy the xml, and save it to disk as a .sqlplan file, and open it in SSMS, it shows as a Key Lookup.
The text was updated successfully, but these errors were encountered: