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

SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they do not exist

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.0.2.0, 10.0.2.1, 10.0.2.2, 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6
    • 10.1.3.2, 10.2.2.0, 10.3.1.4
    • SQL
    • None

    Description

      There must be an entry in the SYSSTATISTICS table in order for the cardinality statistics in SYSSTATISTICS to be created with SYSCS_UTIL.SYSCS_COMPRESS_TABLE

      SYSCS_UTIL.SYSCS_COMPRESS_TABLE should create statistics if they don't exist. The only way to create them if the index was created on an empty table, seems to be to drop and recreate the index after the table has been loaded.

      The documentation will also need updating if this change is made.
      http://db.apache.org/derby/docs/10.1/tuning/ctunstats57373.html

      Attachments

        1. DERBY737_v1_diff_SYSCS_COMPRESS_TABLE.txt
          15 kB
          Mamta A. Satoor
        2. DERBY737_v1_stat_SYSCS_COMPRESS_TABLE.txt
          0.4 kB
          Mamta A. Satoor

        Issue Links

          is related to

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-1964 Update the documentation of SYSCS_UTIL.SYSCS_COMPRESS_TABLE for the changes that went in as part of DERBY-737

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              mamtas Mamta A. Satoor
              kmarsden Katherine Marsden
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: