Re: [jira] Assigned: (DERBY-3787) Document the new system stored procedure SYSCS_UTIL.SYSCS_UPDATE_STATISTICS which was added as part of DERBY-269

[Laura Stewart <sc...@gmail.com>]

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 <Ca...@sun.com> 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