Indexes


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.

Generate Create/Drop Index Commands - Returns 2 lists, one containing the commands to drop all Indexes in a database, the other to create them.

Identify Full or Partial Duplicate Indexes - List either exact duplicate indexes (with key and included columns) or partial duplicates (key columns only).

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

Generate Create/Drop Statements for Missing Indexes - Generates the CREATE/DROP statements for the top 20 system recommendations for missing indexes

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.

Get Index Metadata - Multiple queries that list metadata about all indexes in a database, from counts per table to unused and duplicate indexes

Get Fulltext Index Composition - Get Index composition for all FullText Indexes in a database

Get Fulltext Index Status - Get Index Status for all FullText Indexes in a database