user_seeks Vs user_scan

  • 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.

  • 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

  • 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.

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply