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

[JDBC-STORE] Adding index on txId

XMLWordPrintable

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

      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)

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

                Created:
                Updated:
                Resolved: