In addition, if there is more than one index on a column, it will show the number of indexes in brackets at the start. For example, the IX column might read '(2) c, unique, desc (disable)'
when ix.COLIMN_NAME is not null then
when ix.type_desc = 'CLUSTERED' then 'c'
when ix.type_desc = 'NONCLUSTERED' then 'nc'
This functionality seems not to be working as I have 3 indexes on the same column but still see only “nc, desc” in IX column.
Even the code extract shows that column IX always starts with the index type not the count.
Am I having an old version of the code or is this functionality to be added in future?