[
https://issues.apache.org/jira/browse/DERBY-1160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12785053#action_12785053
]
Knut Anders Hatlen commented on DERBY-1160:
-------------------------------------------
Sounds like a good way to resolve this issue. I agree that NUMFREEPAGES and
ESTIMSPACESAVING give the information requested by the reporter.
> Need a documented way to tell for tables and indexes: a) the number of pages
> allocated b) the number of empty pages
> --------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1160
> URL: https://issues.apache.org/jira/browse/DERBY-1160
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Reporter: Stan Bradbury
>
> Very active systems would benefit from a documented way to determine how many
> empty pages are allocated to an index or table in order to determine whether
> a COMPRESS_TABLE is worth running.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
