[
https://issues.apache.org/jira/browse/DERBY-6942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16067117#comment-16067117
]
Harshvardhan Gupta commented on DERBY-6942:
-------------------------------------------
The example I discussed above was quite a simple example, when there are
multiple joins, the cardinality estimates become important. Since the result of
a particular table node act as outer table for the nested join, errors will
propagate outwards and small errors will become significant. (cost of scans are
determined by multiplication from the total number of rows of outer table if
table locks are being used)
> 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)