[ 
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)

Reply via email to