How to optimize query performance in InterSystems IRIS for large datasets?

 Hi everyone,

I’m currently working with InterSystems IRIS and handling large datasets where some queries are starting to take longer than expected.

So far, I’ve tried basic indexing and reviewing query structures, which helped a bit, but I still feel there is room for improvement. My goal is to reduce response time, especially for frequently used queries in a production environment.

I would like to understand better:

• What are the best practices for indexing in IRIS when working with large volumes of data?

• Are there recommended tools or methods to analyze query performance?

• Is there any specific configuration that helps improve performance in these scenarios?

Any guidance, examples, or documentation references would be really appreciated.

Thanks in advance!