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

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

          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: