SQLTeam.com | Weblogs | Forums

Query to review index definition


#1

Hi,

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


#2

Start by looking at sys.indexes


#3

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?


#4

sys.index_columns contains the index keys