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