Prev: Unix Timestamp Conversion
Next: SQL 2008 FK Issues while Inserting
From: sqlcatz on 11 Sep 2009 05:26
Hello Tibor,

I was searching for information on [sys.dm_db_index_usage_stats] and came
across this thread. A table which exists in our db has 1 Clustered and 1
non-clustered index.
The clustered index has: scans:0 seeks:66 lookups:3848.
The non-clustered index has: scans:0 seeks:5328 lookups:0.

I understand what the numbers mean for the scans & seeks - but the lookup is
confusing me. Can you please point me to a URL which descibes the
[sys.dm_db_index_usage_stats] and how I should interpet the above numbers.

cheers
sqlcatz

 | 
Pages: 1
Prev: Unix Timestamp Conversion
Next: SQL 2008 FK Issues while Inserting