Uploaded image for project: 'OpenMRS Core'
  1. OpenMRS Core
  2. TRUNK-5821

Add indices to order_number and accession_number columns in Order table

    XMLWordPrintable

Details

    • Enhancement
    • Status: Closed
    • Should
    • Resolution: Fixed
    • None
    • Core 2.4.0, Core 2.3.2
    • None
    • Low

    Description

      To speed performance when matching on order and accession number, we'd like to add indices on the order_number and accession_number fields in the Orders table.

      Does anyone see issues with this? burke?

      This involves adding the corresponding liquibase changesets in the liquibase-update-to-latest-2.4.x.xml file.

      Gliffy Diagrams

        Attachments

          Activity

            People

              miirochristopher Christopher Miiro
              mogoodrich Mark Goodrich
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: