Home Forums SQL Server 2008 SQL Server 2008 - General Columns not in key look up, why? RE: Columns not in key look up, why?
yasubmj
Mr or Mrs. 500
Points: 592
More actions
October 15, 2012 at 3:45 am
#1549051
Hmmm... so do you mean that if the other 2 columns (Message, DateTimeStamp) were a part of another index on the table... and were not a part of the index which it is using (PegasusMap), then it would do a key look up on those 2 as well?