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
case
when ix.type_desc = 'CLUSTERED' then 'c'
when ix.type_desc = 'NONCLUSTERED' then 'nc'
else ix.type_desc
end
...
else
@Empty
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?
Regards,
Arko