Derby
  1. Derby
  2. DERBY-269

Provide some way to update index cardinality statistics (e.g. reimplement update statistics)

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.2.2.0, 10.3.1.4
    • Fix Version/s: 10.5.1.1
    • Component/s: SQL
    • Labels:
      None

      Description

      Performance problems are being reported that can be resolved by updating the cardinality statistics used by the optimizer. Currently the only time the statistics are guaranteed to be an up-to-date is when the index is first created on a fully populated table. This is most easily accomplished on an existing table by using the command:

      alter table <table-name> compress [sequential]

      Compress table is an I/O intensive task. A better way to achieve this would be to re-enable parser support for the 'update statistics' command or re-implement the update in some other fashion.

      1. DERBY269_update_statistics_svnstat_ver2.txt
        1 kB
        Mamta A. Satoor
      2. DERBY269_update_statistics_svnstat_ver1.txt
        1 kB
        Mamta A. Satoor
      3. DERBY269_update_statistics_svndiff_ver2.txt
        51 kB
        Mamta A. Satoor
      4. DERBY269_update_statistics_svndiff_ver1.txt
        37 kB
        Mamta A. Satoor

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              Mamta A. Satoor
              Reporter:
              Stan Bradbury
            • Votes:
              6 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development