Index Related DMV Queries

From SQLServerPedia

Jump to: navigation, search

See Also: Main_Page - Transact SQL Code Library

The following Index Performance Tuning queries are included in the T-SQL Code Library:

Find Tables Without Primary Keys - also known as heaps.
Find Indexes Not In Use
Find Missing Indexes
Find Queries in the Plan Cache That Are Missing an Index

Have Problems with These Queries?

You can add questions by clicking on the "Discussion" tab at the top of this article. The authors will see your comments and respond.

Retrieved from "http://sqlserverpedia.com/wiki/Index_Related_DMV_Queries"