September 25, 2012 at 8:51 am
Hi,
I tried finding this (user_seeks Vs user_scan) out on internet but no proper explanation is present for this. I was able to find the difference between index_seeks vs index_scan but i would like to know about what is meant by user_seeks and user_scan.
I don't want the exact difference but what they mean.
September 25, 2012 at 8:55 am
User seeks and scans are those initiated by stored procedures or ad hoc queries issued by users (such as you), as opposed to those initiated by the system.
Roland Alexander
The Monday Morning DBA
There are two means of refuge from the miseries of life: music and cats. ~ Albert Schweitzer
September 25, 2012 at 8:42 pm
I found out that user_seek means number of times when the user issues the command like select fname from emp
and user_scan means the number of time the user issue select * from emp.
September 26, 2012 at 1:14 am
User_seeks will be the number of times a user query could use a seek on the index (execution plan shows an index seek operation), user scans is the number of times that a user query had to scan the index to get the necessary results.
Any select without a where clause will be a scan.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply