Cool Tips‎ > ‎







Get Index Details

Returns a list of all indexes for one or all tables in a database.  Includes details of tables with just a Heap. 

2000, 2005, 2008, 2008R2, 2012


Generate Create/Drop Index Commands

Returns 2 lists, one containing the commands to drop all Indexes in a database, the other to create them. 

2000, 2005, 2008, 2008R2, 2012 


Identify Full or Partial Duplicate Indexes

List either exact duplicate indexes (with key and included columns) or partial duplicates (key columns only).

2000, 2005, 2008, 2008R2, 2012  


Identify Top N Missing Indexes

Lists the system recommendations for indexes that would provide benefit  to currently active queries.  Includes stats on how many times these would have been useful

2000, 2005, 2008, 2008R2, 2012   


Generate Create/Drop Statements for  Missing Indexes

Generates the CREATE/DROP statements for the top 20 system recommendations for missing indexes

2000, 2005, 2008, 2008R2, 2012   


Check if an Update of Index Statistics Required

A function that returns true if >10% of the rows of any index on a table have been modified. 

2000, 2005, 2008, 2008R2, 2012