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

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.6.1.0
    • Component/s: Documentation
    • Labels:
      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.

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

        Activity

        Gavin made changes -
        Workflow jira [ 12352573 ] Default workflow, editable Closed status [ 12799810 ]
        Kathey Marsden made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Bryan Pendleton made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Fix Version/s 10.6.0.0 [ 12313727 ]
        Resolution Fixed [ 1 ]
        Bryan Pendleton made changes -
        Attachment docs2.diff [ 12426816 ]
        Attachment rrefsyscsdiagtables.html [ 12426817 ]
        Bryan Pendleton made changes -
        Attachment docs.diff [ 12426748 ]
        Attachment cadminspace21579.html [ 12426749 ]
        Bryan Pendleton made changes -
        Summary Need a documented way to tell for tables and indexes: a) the number of pages allocated b) the number of empty pages Document use of SPACE_TABLE to tell for tables and indexes: a) the number of pages allocated b) the number of empty pages
        Assignee Bryan Pendleton [ bryanpendleton ]
        Component/s Documentation [ 11406 ]
        Component/s SQL [ 11408 ]
        Mike Matrigali made changes -
        Field Original Value New Value
        Component/s SQL [ 11408 ]
        Stan Bradbury created issue -

          People

          • Assignee:
            Bryan Pendleton
            Reporter:
            Stan Bradbury
          • Votes:
            1 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development