Home Forums Article Discussions Article Discussions by Author Discuss content posted by Devendra Thakur Index Utilization Summary RE: Index Utilization Summary
jonas.gunnarsson 52434
Ten Centuries
Points: 1240
More actions
September 18, 2017 at 7:52 am
#1959787
Nice,Also add schema, first in select"Schema" = object_schema_name(Obj.object_id),And may be the following after the inner join sys.objects Obj on Obj.object_id=Indx.object_id line: and Obj.name <> 'sysdiagrams'
"Schema" = object_schema_name(Obj.object_id),
inner join sys.objects Obj on Obj.object_id=Indx.object_id
and Obj.name <> 'sysdiagrams'