Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

"Key Lookup" shows up as "Clustered Index Seek" #20

Closed
BrentOzar opened this issue Oct 16, 2016 · 1 comment
Closed

"Key Lookup" shows up as "Clustered Index Seek" #20

BrentOzar opened this issue Oct 16, 2016 · 1 comment
Labels
Milestone

Comments

@BrentOzar
Copy link

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.

@JustinPealing JustinPealing added this to the 1.2 milestone Oct 16, 2016
JustinPealing pushed a commit that referenced this issue Oct 16, 2016
@JustinPealing
Copy link
Owner

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:

https://technet.microsoft.com/en-us/library/bb326635(v=sql.105).aspx

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants