Description
Scan over an index if significantly slower than scan over a table. In some cases (for example, TPC-H q1 on scaleFactor=0.1) it's faster to read an entire table and do sorting in memory rather than scan the index.
Let's adjust cost function to reflect the real complexity of index scan.
Attachments
Issue Links
- relates to
-
IGNITE-21579 Sql. Investigate performance bottlenecks in sql engine
-
- Resolved
-
- links to
