According to books online, the user_seeks column contains
Number of seeks by user queries
Now, what is actually "number of seeks". I sincerely thought, that if a query used an index and used a seek operator to get values for 100 rows, then user_seeks would increase by 100. Apparently not. I was running a query seeking up approximately 32000 rows, still the user_seeks only increased by 1. So, I believe that user_seeks is the number of seek operators that has executed against that table.
Am I right in my conclusion here, or have I overlooked something?
Ole Kristian Velstadbråten Bangås - Virinco
Concatenating Row Values in Transact-SQL[/url]