Evgeny Stanilovsky created IGNITE-24591:
-------------------------------------------
Summary: Sql. Improve self cost estimation if pk is involved
Key: IGNITE-24591
URL: https://issues.apache.org/jira/browse/IGNITE-24591
Project: Ignite
Issue Type: Task
Components: sql
Affects Versions: 3.0
Reporter: Evgeny Stanilovsky
Fix For: 3.1
Current implementation of ProjectableFilterableTableScan#computeSelfCost thus
cumulative cost is significantly differ in spite of table scan estimated row
count.
{code:java}
Exchange(distribution=[single]): rowcount = 1.0, cumulative cost = IgniteCost
[rowCount=73050.0, cpu=292197.0, memory=0.0, io=0.0, network=136.0], id = 49
TableScan(table=[[PUBLIC, CATALOG_SALES]], tableId=[5],
filters=[OR(AND(=($t15, 1), =($t17, 1)), AND(=($t15, 3), =($t17, 3)))],
requiredColumns=[{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17,
18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33}]): rowcount =
1.0, cumulative cost = IgniteCost [rowCount=73049.0, cpu=292196.0, memory=0.0,
io=0.0, network=0.0], id = 46
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
