[
https://issues.apache.org/jira/browse/DERBY-4116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mike Matrigali updated DERBY-4116:
----------------------------------
patch looks good to me. The only thing I noticed is that the current index
scans use an open for read (argument 0), but your new heap open does an open
for update. It seems like both
opens should use the same - either read or write, and since the existing scans
and update of the estimate seems to work it seems better to open the heap for
read also.
> SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row
> count for the table
> --------------------------------------------------------------------------------------------
>
> Key: DERBY-4116
> URL: https://issues.apache.org/jira/browse/DERBY-4116
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.5.1.0, 10.6.0.0
> Reporter: Kathey Marsden
> Assignee: Kathey Marsden
> Attachments: derby-4116_diff.txt, derby-4116_diff2.txt,
> derby-4116_diff3.txt
>
>
> When SYSCS_UTIL.SYSCS_UPDATE_STATISTICS is run, it doesn't update the store
> estimated row count. The program oldSelectivity.java attached to DERBY-3955
> shows that the statistics are not updated.
> See discussions in DERBY-3955
> https://issues.apache.org/jira/browse/DERBY-3955?focusedCommentId=12688789&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_12688789
> https://issues.apache.org/jira/browse/DERBY-3955?focusedCommentId=12688813&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_12688813
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
