You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Geoffrey Jacoby (Jira)" <ji...@apache.org> on 2020/07/07 01:05:00 UTC

[jira] [Created] (PHOENIX-5990) Delete statements don't honor index hints

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)