[Video] Smarter Table Statistics

Hey Community!

We're happy to share a new video from our InterSystems Developers YouTube:

⏯  Smarter Table Statistics @ Ready 2025

https://www.youtube.com/embed/k7cOSuydwHI
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

This presentation introduces Collected Table Statistics, a new and more flexible way to manage table statistics in InterSystems IRIS 2025.2. Unlike traditional fixed statistics stored in class definitions, collected stats are stored with data, making them easier to update, version, export, and roll back.
A new automatic collection task keeps statistics current by identifying and updating only the tables that need tuning, with minimal system impact and full configurability. Users can control when and how stats are collected, and choose between fixed or collected stats during query processing.

The feature also works in interoperability environments, improving SQL performance on message and search tables by allowing the engine to prioritize the most effective query conditions.

Presenters:
🗣 Yuchen Liu, Principal Systems Developer, InterSystems
🗣 Minhao Li, Systems Developer, InterSystems

Enjoy watching, and subscribe for more videos! 👍