[
https://issues.apache.org/jira/browse/DERBY-3787?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Laura Stewart reassigned DERBY-3787:
------------------------------------
Assignee: Laura Stewart
As near as I can tell (it's been awhile since I did any Derby documentation
updates :-)
this is what needs to happen to update the documentation with this new built-in
system procedure:
1. A new topic in the Reference Manual needs to be created
2. The name of the new procedure is: SYSCS_UTIL.SYSCS_UPDATE_STATISTICS
3. The syntax is: SYSCS_UTIL.SYSCS_UPDATE_STATISTICS(SCHEMANAME, TABLENAME,
INDEXNAME)
4. SCHEMANAME and TABLENAME are required parameters
5. INDEXNAME is not required, but If the user does not specify the indexname,
then all the indexes on the tablename will have their statistics updated. If
the user does specify an indexname, then statistics will be updated only for
that index.
What I need to know is:
1. What is a good 1-2 sentence description for this procedure. It would be good
to tell the user why having current statistics is useful. Are current status
necessary for getting accurate info from other procedures, functiions, or
utilities?
2. Is there a good example of both the procedure (with realisic parameter names
like CUSTOMER for the tablename)
3. Do you want to show an example of the results of running the procedure?
Thanks, Laura
> 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
>
> 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.
