db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4121) Documentation: more UPDATE_STATISTICS fixes needed for Reference Manual and Tuning Derby
Date Wed, 08 Apr 2009 16:58:13 GMT

     [ https://issues.apache.org/jira/browse/DERBY-4121?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kim Haase updated DERBY-4121:
-----------------------------

    Attachment: DERBY-4121.zip
                DERBY-4121.stat
                DERBY-4121.diff

Looks like this is ready to document, so I may as well pick it up. I have attached DERBY-4121.diff,
DERBY-4121.stat, and DERBY-4121.zip, with changes to two files:

M      src/tuning/ctunstats849505.dita
M      src/ref/rrefupdatestatsproc.dita

The Tuning change adds a paragraph to the suggested topic on statistics.

The Ref change corrects the two examples; includes the information about when to call the
procedure; and inserts the conrefs.dita phrase for Derby. 

I have thought of one more item for the Reference topic, though. The syntax has no indication
of the data types of the three arguments:

SYSCS_UTIL.SYSCS_UPDATE_STATISTICS(SCHEMANAME, TABLENAME, INDEXNAME)

Shouldn't this be changed to something like the following?

SYSCS_UTIL.SYSCS_UPDATE_STATISTICS(IN SCHEMANAME VARCHAR(128), IN TABLENAME VARCHAR(128),
IN INDEXNAME VARCHAR(128))

Compare http://db.apache.org/derby/docs/dev/ref/rrefimportproc.html and other procedure syntax
statements. 

Thanks for any comments.

> Documentation: more UPDATE_STATISTICS fixes needed for Reference Manual and Tuning Derby
> ----------------------------------------------------------------------------------------
>
>                 Key: DERBY-4121
>                 URL: https://issues.apache.org/jira/browse/DERBY-4121
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.5.0.0
>            Reporter: Kim Haase
>            Priority: Minor
>         Attachments: DERBY-4121.diff, DERBY-4121.stat, DERBY-4121.zip
>
>
> Kathey Marsden comments on DERBY-3787:
> Not a show stopper for the release, but in beginning my buddy testing,
>  I noticed the examples should use CALL e.g.
> CALL SYSCS_UTIL.SYSCS_UPDATE_STATISTICS('SAMP','EMPLOYEE','PAY_DESC');
> CALL SYSCS_UTIL.SYSCS_UPDATE_STATISTICS('SAMP', 'EMPLOYEE', null);
> Also in the Tuning Guide under Working with Cardinality Statistics -> When Cardinality
Statistics Go Stale we should refer users to the SYSCS_UTIL.SYSCS_UPDATE_STATISTICS stored
procedure to update their statistics and cross reference the reference guide.
> Myrna van Lunteren suggests a new issue for this, so I'm filing it.

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