[jira] [Work logged] (ARTEMIS-2465) [JDBC-STORE] Adding index on txId

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ARTEMIS-2465?focusedWorklogId=302931&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-302931 ]

ASF GitHub Bot logged work on ARTEMIS-2465:
-------------------------------------------

                Author: ASF GitHub Bot
            Created on: 28/Aug/19 14:47
            Start Date: 28/Aug/19 14:47
    Worklog Time Spent: 10m 
      Work Description: franz1981 commented on pull request #2814: ARTEMIS-2465 [JDBC-STORE] Adding index on txId
URL: https://github.com/apache/activemq-artemis/pull/2814
 
 
   
 
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Issue Time Tracking
-------------------

            Worklog Id:     (was: 302931)
    Remaining Estimate: 0h
            Time Spent: 10m

> [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: 10m
>  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)