Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-1160

Document use of SPACE_TABLE to tell for tables and indexes: a) the number of pages allocated b) the number of empty pages

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 10.6.1.0
    • Documentation
    • None

    Description

      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.

      Attachments

        1. docs.diff
          1 kB
          Bryan Pendleton
        2. cadminspace21579.html
          7 kB
          Bryan Pendleton
        3. docs2.diff
          5 kB
          Bryan Pendleton
        4. rrefsyscsdiagtables.html
          22 kB
          Bryan Pendleton

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            bryanpendleton Bryan Pendleton
            stan Sun Seng David Tan
            Votes:
            1 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment