SEEK - find everything from index
Lookup - find key from index, then visit table to find other row data.
http://www.theboreddba.com/Categories/indexes/What-is-a-Key-Lookup.aspx
SEEK - find everything from index
Lookup - find key from index, then visit table to find other row data.
http://www.theboreddba.com/Categories/indexes/What-is-a-Key-Lookup.aspx
转载于:https://www.cnblogs.com/tang88seng/p/11200696.html