Docs could be clearer on what SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE does with
statistics
------------------------------------------------------------------------------------------
Key: DERBY-4289
URL: https://issues.apache.org/jira/browse/DERBY-4289
Project: Derby
Issue Type: Improvement
Components: Documentation
Affects Versions: 10.5.1.1
Environment: Solaris
Reporter: Alan Burlison
Priority: Minor
The documentation for SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE says:
"Use the SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE system procedure to reclaim
unused, allocated space in a table and its indexes."
The documentation for SYSCS_UTIL.SYSCS_COMPRESS_TABLE says in addition:
"The SYSCS_UTIL.SYSCS_COMPRESS_TABLE system procedure updates statistics on all
indexes as part of the index rebuilding process."
I'm assuming SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE also rebuilds the
statistics, but the documentation doesn't day either way.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
