db2 "set current explain mode explain"
db2 -tvf test.sql
db2 "set current explain mode no"
db2exfmt -d xxdb -g TIC -w -1 -n % -s % -# 0 -o  ./explain.txt

9) TBSCAN: (Table Scan)
        Cumulative Total Cost:         305.174
        Cumulative CPU Cost:         1.19168e+08
        Cumulative I/O Cost:         275
        Cumulative Re-Total Cost:     25.421
        Cumulative Re-CPU Cost:     1.17423e+08
        Cumulative Re-I/O Cost:     0
        Cumulative First Row Cost:     305.167
        Estimated Bufferpool Buffers:     275

        Arguments:
        ---------
        CUR_COMM: (Currently Committed)
            TRUE
        JN INPUT: (Join input leg)
            OUTER
        LCKAVOID: (Lock Avoidance)
            TRUE
        MAXPAGES: (Maximum pages for prefetch)
            ALL
        PREFETCH: (Type of Prefetch)
            SEQUENTIAL          
        ROWLOCK : (Row Lock intent)
            SHARE (CS/RS)
        SCANDIR : (Scan Direction)
            FORWARD
        SKIP_INS: (Skip Inserted Rows)
            TRUE
        SPEED   : (Assumed speed of scan, in sharing structures)
            SLOW
        TABLOCK : (Table Lock intent)
            INTENT SHARE
        TBISOLVL: (Table access Isolation Level)
            CURSOR STABILITY
        THROTTLE: (Scan may be throttled, for scan sharing)
            TRUE
        VISIBLE : (May be included in scan sharing structures)
            TRUE
        WRAPPING: (Scan may start anywhere and wrap)
            TRUE

        Predicates:
        ----------
        8) Sargable Predicate, 
            Comparison Operator:         Equal (=)
            Subquery Input Required:     No
            Filter Factor:             2.14353e-05

            Predicate Text:
            --------------
            (Q3.NAME = 'S_CARRIER_CarrierSourceType')


        17) Sargable Predicate, 
            Comparison Operator:         Equal (=)
            Subquery Input Required:     No
            Filter Factor:             2.72598e-05

            Predicate Text:
            --------------
            (Q3.VALUE = 'xx')



        Input Streams:
        -------------
            1) From Object xx.xxxx

                Estimated number of rows:     46651
                Number of columns:         4
                Subquery predicate ID:         Not Applicable

                Column Names:
                ------------
                +Q3.$RID$+Q3.VALUE+Q3.NAME+Q3.D_THESYSTEMKEY


        Output Streams:
        --------------
            2) To Operator #8

                Estimated number of rows:     2.72592e-05
                Number of columns:         2
                Subquery predicate ID:         Not Applicable

                Column Names:
                ------------
                +Q3.VALUE+Q3.D_THESYSTEMKEY

版权声明：本文为博主原创文章，未经博主允许不得转载。

DB2