Cool Tips‎ > ‎

Indexes

 

Title

Description

Applicability

 

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    

 

 


 

 


Comments