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)