Aleksey Plekhanov created IGNITE-16507:
------------------------------------------
Summary: Calcite engine. Redundant sort node when rewriting index
scan on index rebuild
Key: IGNITE-16507
URL: https://issues.apache.org/jira/browse/IGNITE-16507
Project: Ignite
Issue Type: Improvement
Reporter: Aleksey Plekhanov
When the query plan has an index scan, but the index is rebuilding we rewrite
this scan to the chain of table scan/sort/spool/project nodes (see
IGNITE-16111). In some cases sort node is redundant, but still created, for
example, when index scan is used only for filtering:
{noformat}
SELECT * FROM emp WHERE dep_id = 10
{noformat}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
