db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Laura Stewart (JIRA)" <j...@apache.org>
Subject [jira] Assigned: (DERBY-3787) Document the new system stored procedure SYSCS_UTIL.SYSCS_UPDATE_STATISTICS which was added as part of DERBY-269
Date Fri, 06 Mar 2009 05:03:56 GMT

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


Mime
View raw message