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