[ https://issues.apache.org/jira/browse/ARTEMIS-2465?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16924500#comment-16924500 ]
ASF subversion and git services commented on ARTEMIS-2465: ---------------------------------------------------------- Commit fb01bc5644405d61b9eaa70d34688bfdddca24b6 in activemq-artemis's branch refs/heads/master from Francesco Nigro [ https://gitbox.apache.org/repos/asf?p=activemq-artemis.git;h=fb01bc5 ] ARTEMIS-2465 [JDBC-STORE] Adding index on txId > [JDBC-STORE] Adding index on txId > --------------------------------- > > Key: ARTEMIS-2465 > URL: https://issues.apache.org/jira/browse/ARTEMIS-2465 > Project: ActiveMQ Artemis > Issue Type: Improvement > Components: Broker > Affects Versions: 2.10.0 > Reporter: Francesco Nigro > Priority: Major > Time Spent: 20m > Remaining Estimate: 0h > > 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. > {code:sql} > create-journal-index=CREATE INDEX %1$s_IDX ON %1$s (id) > {code} -- This message was sent by Atlassian Jira (v8.3.2#803003)