phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Geoffrey Jacoby (Jira)" <j...@apache.org>
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
                 URL: https://issues.apache.org/jira/browse/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
(v8.3.4#803005)

Mime
View raw message