This report is very useful – you can use it to tune your system, plan your space layout and your maintenance. It shows information about the indexes on your tables, the types they are, and how often they are accessed. If you want more information about indexes in general, check here. Indexes are accessed in multiple ways – there are scan operations, which read the index from the top to the bottom, seek operations, which look for a specific entry or a range of entries, lookup operations, which look for a specific entry and so on. In addition to the way the index is used, the type of index is important as well. This is a great reference to read about which query type will use which type index.
The first band in the report groups the information by the Table Name:
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re
PingBack from http://www.biosensorab.org/2008/02/06/sql-server-management-studio-standard-reports-%e2%80%93-index-usage-statistics-databasename/