Iurii Gerzhedovich created IGNITE-22703:
-------------------------------------------
Summary: Sql. Low performance for select with mixed projection
Key: IGNITE-22703
URL: https://issues.apache.org/jira/browse/IGNITE-22703
Project: Ignite
Issue Type: Improvement
Components: sql
Reporter: Iurii Gerzhedovich
We have low performance in case we reorder columns in SELECT statement.
Below result of my laptop for SELECT from a table with 600k rows. The first one
is to select all columns in the same order as was declared during creating the
table, the second one - reorder the first and the second columns in the select
list.
||Benchmark||(queryId) ||Mode||Cnt||Score||Error||Units||
|TpchBenchmark.run |1|avgt|20|206.522|± 1.167|ms/op|
|TpchBenchmark.run |2|avgt|20|784.153|± 1.792|ms/op|
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
