[ https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16067124#comment-16067124 ]
Harshvardhan Gupta commented on DERBY-6942: ------------------------------------------- In particular, when estimating cost for a particular conglomerate, it would be good if we start looking at other conglomerates' statistics for cardinality estimates. For example during table scan, we can start adjusting cardinality estimates using the statistics for index. Note that cost and cardinality are two different concepts, cost will always be determined by the number and size of pages / rows that a particular access path has to read to execute its work. Table scan's cost will remain unaffected here in this case by changing thecardinality estimates. (However, index scan's cost and cardinality estimates will be co-related in our particular example) > Utilise additional statistics for selectivity estimates. > -------------------------------------------------------- > > Key: DERBY-6942 > URL: https://issues.apache.org/jira/browse/DERBY-6942 > Project: Derby > Issue Type: Sub-task > Components: SQL > Reporter: Harshvardhan Gupta > Assignee: Harshvardhan Gupta > Priority: Minor > -- This message was sent by Atlassian JIRA (v6.4.14#64029)