Trafodion

  1. Bug #1398600
  2. Comment #2

Comment 2 for bug 1398600

Revision history for this message
Trafodion-Gerrit (neo-devtools) wrote : Fix merged to core (master)

Reviewed: https://review.trafodion.org/755
Committed: https://github.com/trafodion/core/commit/4313fc292d268d99f7603af6e6884ae785c13f00
Submitter: Trafodion Jenkins
Branch: master

commit 4313fc292d268d99f7603af6e6884ae785c13f00
Author: Mike Hanlon <email address hidden>
Date: Wed Dec 3 18:02:46 2014 +0000

    Fix performance regression due to QI for DDL

    This check-in omits object UIDs from query plans for the tables
    SB_HISTOGRAMS and SB_HISTOGRAMS_INTERVALS. Previously, when the
    code generator tried to add the object UIDs for these, it had to
    make a special query to the metadata, since the corresponding
    internal cached structure omitted object UIDs when they were
    created via methods like Generator::createVirtualTableDesc. The
    special query to lookup these object UIDs was shown to be
    responsible for a large pathlengh regression.

    Change-Id: Id5046c5c55a4fc8dd2ba3f891449ea87d35a5534
    Closes-Bug: #1398600