Why is there a key lookup even though I have non clustered index?
I am facing an issue where key lookup is shown in query plan even though I
have created indexes on IsGrantor and IsGrantee. Please see the attached
screenshot and output list.
The table roughly contains about 0.5 million records.
Any help would be appreciated.
No comments:
Post a Comment