Skip to Main Content
InterSystems Ideas
We love hearing from our users. Tell us what you want to see next and upvote ideas from the community.
* Bugs and troubleshooting should as usual go through InterSystems support.
Status Already exists
Created by Steve Pisani
Created on Jul 28, 2023

Identify redundant indices

Over time, application developer define indices to improve their query performance. Over time, it's possible that some query definition may not be used and therefore (a) consume processing time during filing and (b) consume diskspace, journal spaces etc. We have tools to list out all defined indices, but nothing to tell us if, a defined query is ever used.
    Sep 13, 2023

    Thank you for posting the idea. According to information from experts, this functionality already exists.

  • Admin
    Vadim Aniskin
    Aug 3, 2023

    @Steve Pisani, there is a comment on your idea. Please reply to help promote your idea.

  • Alexander Koblov
    Jul 31, 2023

    System Explorer -> Tools -> SQL Performance Tools -> Index Analyzer -> Index Usage shows usage count for each index.

    Is that something that you are looking for ?

    2 replies