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

RID Lookup operator shown as Key Lookup (Clustered) in Explain Plan or Actual Plan #391

Closed
HugoKornelis opened this issue Dec 21, 2017 · 1 comment
Labels
Milestone

Comments

@HugoKornelis
Copy link

  • SQL Operations Studio Version: 0.24.1

Steps to Reproduce:
Connect to AdventureWorks2012 and paste in this query:
SELECT *
FROM dbo.DatabaseLog
WHERE DatabaseLogID BETWEEN 195 AND 198;
Click Explain, or select Run Current Query with Actual Plan from the Command Palette.

The resulting plan includes an operator "Key Lookup (Clustered)".
afbeelding
The corresponding node in the showplan's XML reads:
<RelOp NodeId="3" PhysicalOp="RID Lookup" LogicalOp="RID Lookup" (...) >

The node showing a Key Lookup should show an RID Lookup instead,

@kburtram
Copy link
Member

The related upstream bug is closed and we've picked a vbump. So I'll close this now. Please reactive if the issue persists.

@adsbot adsbot bot locked and limited conversation to collaborators Mar 14, 2019
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
Projects
None yet
Development

No branches or pull requests

3 participants