Uploaded image for project: 'AMQ Broker'
  1. AMQ Broker
  2. ENTMQBR-2803

[JDBC-STORE] Adding index on txId

    XMLWordPrintable

Details

    • Story
    • Resolution: Done
    • Major
    • AMQ 7.6.0.CR1
    • AMQ 7.4.0.GA
    • broker-core
    • None
    • AMQ Broker 4719

    Description

      An index is only created on ID column not on txid, due to which full table scan is happening while executing DELETE FROM MESSAGE_TABLE WHERE txId=:1 query.

      create-journal-index=CREATE INDEX %1$s_IDX ON %1$s (id)

      Attachments

        Issue Links

          is cloned by

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. ENTMQBR-3951 [LTS] [JDBC-STORE] Adding index on txId

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              fnigro Francesco Nigro
              rhn-support-shsingh Shailendra Singh
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: