Konstantin Orlov created IGNITE-23188:
-----------------------------------------
Summary: Sql. Incorporate table size estimation in query optimizer
Key: IGNITE-23188
URL: https://issues.apache.org/jira/browse/IGNITE-23188
Project: Ignite
Issue Type: Improvement
Components: sql
Reporter: Konstantin Orlov
As of now, the size of every table in cluster is hardcoded to 10k rows, which
prevents cost-based planner from providing best plan.
In IGNITE-22619 method returning estimated size of a particular table has been
introduced. Sql engine may take an advantage of this method in order to improve
quality of returned plans.
Let's incorporate proper table size estimation in query optimization pipeline.
Note: call to {{org.apache.ignite.internal.table.InternalTable#estimatedSize}}
results in distributed call to primary replicas of all partitions of the table,
those it's better to throttle it. Also, table size estimation must return the
same number of rows within a single optimization session.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
