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 Implemented
Categories InterSystems IRIS
Created by David Hockenbroch
Created on Apr 21, 2025

Store table tuning statistics with globals, not routines

Currently, table tuning data is part of a class definition. Many of us are splitting routines and globals into different databases to keep the data and the code separate. This causes a problem because we have many situations where we want the same routines across multiple namespaces, but the outliers in the data are different in each of them. For example, in my specific case, we have some customers with stores in multiple locations. Because of this, if we tune the table in one namespace, it is incorrectly tuned in other namespaces and harms their performance.

  • ADMIN RESPONSE
    Aug 20, 2025

    Thank you for submitting the idea.

    This idea was implemented by InterSystems.

  • Benjamin De Boe
    Aug 20, 2025

    Hi, I think we have good news for you :-)

    We were able to implement a new model for smarter table stats that live with the data and released it with 2025.2: https://community.intersystems.com/post/towards-smarter-table-statistics