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