phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Geoffrey Jacoby (Jira)" <>
Subject [jira] [Created] (PHOENIX-5990) Delete statements don't honor index hints
Date Tue, 07 Jul 2020 01:05:00 GMT
Geoffrey Jacoby created PHOENIX-5990:

             Summary: Delete statements don't honor index hints
                 Key: PHOENIX-5990
             Project: Phoenix
          Issue Type: Bug
            Reporter: Geoffrey Jacoby

While investigating a perf issue with a delete statement, we noticed that the query optimizer
wasn't using an index with a better (though not complete) match for the WHERE clause than
the base table PK was. Even using a query hint to specify the index did not seem to change
the EXPLAIN plan. 

This message was sent by Atlassian Jira

View raw message