This is documentation for Caché and Ensemble. See the InterSystems IRIS version of this content.Opens in a new tab

Please read this important announcement about the future of Caché and Ensemble maintenanceOpens in a new tab. Contact your account team to migrate to InterSystems IRIS.

Sorry, your browser does not support JavaScript or JavaScript is disabled. Please enable JavaScript or use another browser to have a better experience.

Index Usage Analysis

You can analyze index usage by SQL cached queries using either of the following:

The Management Portal Index Analyzer SQL performance tool.
The %SYS.PTools.SQLUtilitiesOpens in a new tab methods IndexUsage()Opens in a new tab, TableScans()Opens in a new tab, TempIndices()Opens in a new tab, and JoinIndices()Opens in a new tab.

Index Analyzer

Index Configuration Options

Feedback