View Single Post
Old September 23rd, 2007, 08:56 AM   #3 (permalink)
pgowder
Member
Verified Customer
 
Join Date: Mar 2002
Posts: 499
Quote:
Originally Posted by Chuck S View Post
That is not a large rowscan. That should a very explicit result as thats what the query is asking for a specific record, there is no pulling of unneeded information.
Then why did it examine 17k rows to get the result?
pgowder is offline   Reply With Quote