Laura, it's wonderful to have you back on the project! Hope you get the
answers you need for this issue.
Kim Haase
On 03/06/09 00:03, Laura Stewart (JIRA) wrote:
[
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.
