[
https://issues.apache.org/jira/browse/IGNITE-24591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky resolved IGNITE-24591.
-----------------------------------------
Resolution: Not A Problem
> 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
> Priority: Major
> Labels: ignite-3
> 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)
