Details

      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)
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  fnigro Francesco Nigro
                  Reporter:
                  dbruscin Domenico Francesco Bruscino
                  Tester:
                  Roman Vais
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: