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

[LTS] [JDBC-STORE] Adding index on txId

XMLWordPrintable

      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
              dbruscin Domenico Francesco Bruscino
              Roman Vais Roman Vais (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: