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 Needs review
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
    Feb 4, 2025

    Thank you for submitting the idea. The status has been changed to "Needs review".

    Stay tuned!