Uploaded image for project: 'Apache Trafodion (Retired)'
  1. Apache Trafodion (Retired)
  2. TRAFODION-2618

SET ROWCOUNT option in UPDATE STATISTICS doesn't suppress rowcount logic

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.0-incubating
    • 2.2.0
    • sql-cmp
    • None
    • Any

    Description

      There is an undocumented option in the update statistics command:

      update statistics ... sample ... set rowcount <num>

      This "set rowcount" option is meant to avoid the need to get an approximate rowcount of the table before reading a sample. However, it seems that update statistics still invokes at least some code to get a rowcount, even in the presence of this option.

      This issue is somewhat related to TRAFODION-2617. We tried the "set rowcount" option as a possible workaround for TRAFODION-2617 but still got the same error.

      Attachments

        Issue Links

          Activity

            People

              hzeller Hans Zeller
              hzeller Hans Zeller
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: