You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Istvan Toth (Jira)" <ji...@apache.org> on 2023/06/19 09:06:00 UTC

[jira] [Created] (PHOENIX-6983) Add hint to disable server merges for uncovered index queries

Istvan Toth created PHOENIX-6983:
------------------------------------

             Summary: Add hint to disable server merges for uncovered index queries
                 Key: PHOENIX-6983
                 URL: https://issues.apache.org/jira/browse/PHOENIX-6983
             Project: Phoenix
          Issue Type: Improvement
          Components: core
    Affects Versions: 5.1.3, 5.2.0
            Reporter: Istvan Toth


In certain cases, the new server merge code is far less efficient than the old skip-scan-merge code path.

Specifically, when a large number of rows is matched on the index table, then each of those rows has to be resolved from the data table, and the filtering must be done on the index RS.

With the old code path, these filters were pushed to the data table, and processed in parallel, with much better performance.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)