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)