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.
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.
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