[ARTEMIS-2465] [JDBC-STORE] Adding index on txId

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.10.0
• Fix Version/s: 2.10.1
• Component/s: Broker
• Assignee: Unassigned
• Reporter: Francesco Nigro
• Created: 28/Aug/19 14:43
• Updated: 23/Sep/19 18:57
• Resolved: 23/Sep/19 18:57

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)

Issue Links

• links to: GitHub Pull Request #2814