Aleksey Plekhanov created IGNITE-24664:
------------------------------------------
Summary: Calcite engine. Use _key_PK index scan instead of hash
index scan if possible
Key: IGNITE-24664
URL: https://issues.apache.org/jira/browse/IGNITE-24664
Project: Ignite
Issue Type: Improvement
Reporter: Aleksey Plekhanov
Looks like _key_PK index scan is more effective than hash index scan. Hash
index scan requires also entity type check, but _key_PK index scan only built
for required entity type, so type check can be skipped.
H2 engine uses PK index scan for table scans (see H2TableScanIndex.delegate()
method).
Calcite engine should also use PK index scan when indexes are in correct state.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
