InterSystems Ideas

Have an idea, suggestion, or something that doesn’t work as expected in InterSystems products or services? Share it here on the InterSystems Ideas Portal.

The Ideas Portal is where community members can propose improvements, report bugs, and help influence the product roadmap across InterSystems products and the overall developer experience. 22% of submitted ideas are implemented by InterSystems or members of the Developer Community.

💡 Ideas and bugs are both welcome, no matter how big or small. You can submit feature requests, usability improvements, workflow suggestions, and bug reports. Whether you’re an experienced expert or just getting started, your fresh perspective is valuable.

🛠️ About bugs and fixes. If you have access to InterSystems WRC, please submit bugs there for immediate action. Bug reports submitted through the Ideas Portal are reviewed and tracked, but do not guarantee immediate resolution.

Start by sharing what could be better - the community and our teams will help take it from there.

Add a new idea Subscribe
Status Already exists
Categories InterSystems Products
Created by Steve Pisani
Created on Jul 28, 2023

RELATED IDEAS

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.
  • ADMIN RESPONSE
    Sep 13, 2023

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

  • Post comment
  • Admin
    Vadim Aniskin
    Aug 3, 2023

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

    Reply
  • 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