Skip to Main Content
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.

Status Will not implement
Created by Stella Ticker
Created on Feb 4, 2025

Add EncounterNumber Index to HSAA.Encounter

Adding an index on EncounterNumber in HSAA.Encounter will significantly enhance query performance by reducing full table scans, optimizing joins, and accelerating data retrieval for reporting and analytics. Many reports and queries rely on filtering or joining by EncounterNumber, and without an index, these operations require scanning large volumes of data, leading to slower response times and increased system load. By indexing this column, queries can leverage efficient lookups, reducing execution time, minimizing database contention, and improving overall system performance, especially when handling high volumes of concurrent requests.

  • ADMIN RESPONSE
    Mar 30, 2025

    Thank you for submitting the idea. Based on information from our experts the status of your idea was changed to "Will not implement". Please look for details in the comments on the idea. Good luck!