db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3787) Document the new system stored procedure SYSCS_UTIL.SYSCS_UPDATE_STATISTICS which was added as part of DERBY-269
Date Mon, 09 Mar 2009 18:13:50 GMT

    [ https://issues.apache.org/jira/browse/DERBY-3787?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12680221#action_12680221
] 

Mamta A. Satoor commented on DERBY-3787:
----------------------------------------

Laura, thanks for such a quick turnaround. 

One comment on the page for the example with null for index name. What null indicates is create
all the missing stats and update all the existing stats. I think the following line (expecially
"because there are no statistics for these indexes") might not clearly indiciate that.
"In the following example, the system procedure creates statistics on all of the indexes on
the EMPLOYEE table in the SAMP schema because there are no statistics for these indexes:"

In addition, I wonder if we should have this page linked to other parts of the doc where we
might talk about statistics(specifically missing/outdated statistics).


> Document the new system stored procedure SYSCS_UTIL.SYSCS_UPDATE_STATISTICS which was
added as part of DERBY-269
> ----------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3787
>                 URL: https://issues.apache.org/jira/browse/DERBY-3787
>             Project: Derby
>          Issue Type: Task
>          Components: Documentation
>    Affects Versions: 10.5.0.0
>            Reporter: Mamta A. Satoor
>            Assignee: Laura Stewart
>         Attachments: rrefupdatestatsproc.html
>
>
> DERBY-269 added a new system stored procedure in Derby 10.5 to provide the users a way
to update the statistics for all the indexes or one specific index on a table. We should document
this in our documentation.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message