SQLTeam.com | Weblogs | Forums

Query to review index definition



What is the query to check all the indexes and their index definition as well as the index_keys and total reads in one table.

Thank you


Start by looking at sys.indexes


Hi djj55,

I did but I dont see the index_keys inside the Index names. Is there a setup I need to do so I can see the Index_keys?


sys.index_columns contains the index keys