You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Laura Stewart (JIRA)" <ji...@apache.org> on 2009/03/06 06:03:56 UTC
[jira] Assigned: (DERBY-3787) Document the new system stored
procedure SYSCS_UTIL.SYSCS_UPDATE_STATISTICS which was added as part of
DERBY-269
[ 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.
Re: [jira] Assigned: (DERBY-3787) Document the new system stored
procedure SYSCS_UTIL.SYSCS_UPDATE_STATISTICS which was added as part of
DERBY-269
Posted by 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
Re: [jira] Assigned: (DERBY-3787) Document the new system stored
procedure SYSCS_UTIL.SYSCS_UPDATE_STATISTICS which was added as part of
DERBY-269
Posted by Kim Haase <Ca...@Sun.COM>.
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.
>