Thanks Kim. It is good to be back... I won't be really active initially... I seem to have forgotten my password for committing patches :-)
On Fri, Mar 6, 2009 at 8:27 AM, Kim Haase <[email protected]> wrote: > 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. >> > -- Laura Stewart
