SQL SQL Index SEEK VS Lookup

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