Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-1789

Create the histogram metadata tables at schema creation time

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      Today the histograms and histograms_intervals tables are created only when the first update stats is run on a table in the schema.

      It would be good to create these tables when the schema is created. This will help applications that try to look up rowcounts for example. If there is no entry in the the table, they can default to 0 but if the table does not exist then the application query itself will fail.

        Attachments

          Activity

            People

            • Assignee:
              rmarton Roberta Marton
              Reporter:
              venkatmu Venkat Muthuswamy
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: