Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Sample batch report for Workload Access Path Compare

The following figure shows a sample of the batch version of the Compare report sorted by cost difference. 

Tip

 If the field is too narrow to display all characters, the product alters the display as follows:

  • For numbers, the product attempts to show the number up to the decimal point. If this is not possible, asterisks (*) fill the entire field.
  • For characters, the product truncates the character text from the right.

To change the field widths, customize the report layout.

Related topics

Changing-the-layout-of-the-compare-report

Working-with-workload-comparison-reports

 1--SQL EXPLORER 13.01.00 PARMS- RELEASED JUNE 2022 COMPILED MAR 11 2022
 (C) COPYRIGHT 1996 - 2022 BMC SOFTWARE, INC.
  TITLE='BATCH COMPARE REPORT DEBF TO DEDR V8V9DIFF PG'
  SUMRPT=Y
  SORTORDER=1
  SHOWSQL=Y
  SHOWOBJ=Y
1'BATCH COMPARE REPORT DEBF TO DEDR V8V9DIFF PG'                                                                               1
0STATEMENT SUMMARY IN DESCENDING COST DIFFERENCE ORDER
0PLAN      PROGRAM   STMT   STMT    COST      WEIGHTED  DIFFERENCE
 NAME      NAME      NUMBER,NUMBER  DIFF      COSTDIFF  IN
 --------  --------  -------------  --------  --------  ----------
           V8V9DIFF     304,   304         7         7  PATH STATS INDEX
           V8V9DIFF     297,   297         5         5  PATH STATS INDEX
           V8V9DIFF     290,   290         4         4  PATH STATS INDEX
 ____________________________________________________________________________________________________________________________________
 PROGRAM, SQL TEXT AND ACCESS PATH INFORMATION FOR EACH STATEMENT
0     EXPL SRC                                                             STMT    EXEC WEIGHTED WEIGHTED                     DIFF
 LABL SSID SSID NAME     COLLID       VERSION                    STMTNO    COST   COUNT     COST     DIFF                       IN
 ---- ---- ---- -------- ------------ -------------------------- ------ ------- ------- -------- -------- ------------------------
 XD01 DEDR DEDR V8V9DIFF V8V9DICI     V1.01                         290*      5       1*       5        4 PATH STATS INDEX
 XD00 DEBF DEBF V8V9DIFF V8V9DICI     V1.01                         290       20111   1        1
      SRC  EXPLAIN
 LABL TYPE TIME
 ---- ---- --------------------------
 XD01 C    yyyy-mm-dd-14.25.36.790000
 XD00 C    yyyy-mm-dd-14.22.43.290000
  DECLARE  CUR-V8V9DIFF-ONE CURSOR FOR
  SELECT   COLUMN_3_CHAR_12
  FROM     V8V9DFTB
  WHERE    COLUMN_3_CHAR_12 = 'ABC'
  FOR      FETCH ONLY
           QB PL M TB AC MT                              I  NEW  COMP P C MX LCK J P J QBLOCK TABLE    INDEX    TB AC AC J JN SC SN
      LABL BL NO E NO TY CL TABLE        INDEX           O  UJOG UJOG F F SQ MOD C R T TYPE   CREATOR  CREATOR  TY DG PG D PG PG PG
      ---- -- -- - -- -- -- ------------ --------------- -- ---- ---- - - -- --- - - - ------ -------- -------- -- -- -- - -- -- --
      XD01  1  1 0  1 I * 0 V8V9DFTB    *V8V9DFTB_INDEX3 Y  NNNN NNNN*S    0  IS 0     SELECT V8V9DIFF V8V9DIFF T   0  0 0  0  0  0
      XD00  1  1 0  1 I   1 V8V9DFTB     V8V9DFTB_INDEX4 Y  NNNN NNNN      0  IS 0     SELECT V8V9DIFF V8V9DIFF T   0  0 0  0  0  0
           P CORR GROUP  W OPT  HINT P PA
      LABL M NAME MEMBER O HINT USED A QB
      ---- - ---- ------ - ---- ---- - --
      XD01                              0
      XD00                              0
 ___________________________________________________________________________________________________________________________________
      EXPL SRC                                                             STMT    EXEC WEIGHTED WEIGHTED                     DIFF
 LABL SSID SSID NAME     COLLID       VERSION                    STMTNO    COST   COUNT     COST     DIFF                       IN
 ---- ---- ---- -------- ------------ -------------------------- ------ ------- ------- -------- -------- ------------------------
 XD01 DEDR DEDR V8V9DIFF V8V9DICI     V1.01                         304*      8       1*       8        7 PATH STATS INDEX
 XD00 DEBF DEBF V8V9DIFF V8V9DICI     V1.01                         304       1       1        1
      SRC  EXPLAIN
 LABL TYPE TIME
 ---- ---- --------------------------
 XD01 C    yyyy-mm-dd-14.25.36.940000
 XD00 C    yyyy-mm-dd-14.22.43.460000
  DECLARE  CUR-V8V9DIFF-THREE CURSOR FOR
  SELECT   COLUMN_20
  FROM     V8V9DFTB
  WHERE    COLUMN_2_SML_SHORT = 1
    AND    COLUMN_3_CHAR_12 = 'ABC'
    AND    KEY1_INTEGER_SHORT = 32123
    AND    COLUMN_17 = 34
    AND    COLUMN_19 = 'WHATS UP DOC'
    AND    COLUMN_20 = 23
  FOR      FETCH ONLY
           QB PL M TB AC MT                              I  NEW  COMP P C MX LCK J P J QBLOCK TABLE    INDEX    TB AC AC J JN SC SN
1'BATCH COMPARE REPORT DEBF TO DEDR V8V9DIFF PG'                                                                               2
0     LABL BL NO E NO TY CL TABLE        INDEX           O  UJOG UJOG F F SQ MOD C R T TYPE   CREATOR  CREATOR  TY DG PG D PG PG PG
      ---- -- -- - -- -- -- ------------ --------------- -- ---- ---- - - -- --- - - - ------ -------- -------- -- -- -- - -- -- --
      XD01  1  1 0  1 I * 0 V8V9DFTB    *V8V9DFTB_INDEX3 Y  NNNN NNNN*S    0  IS 0     SELECT V8V9DIFF V8V9DIFF T   0  0 0  0  0  0
      XD00  1  1 0  1 I   6 V8V9DFTB     V8V9DFTB_INDEX2 Y  NNNN NNNN      0  IS 0     SELECT V8V9DIFF V8V9DIFF T   0  0 0  0  0  0
           P CORR GROUP  W OPT  HINT P PA
      LABL M NAME MEMBER O HINT USED A QB
      ---- - ---- ------ - ---- ---- - --
      XD01                              0
      XD00                              0
 ____________________________________________________________________________________________________________________________________
      EXPL SRC                                                             STMT    EXEC WEIGHTED WEIGHTED                     DIFF
 LABL SSID SSID NAME     COLLID       VERSION                    STMTNO    COST   COUNT     COST     DIFF                       IN
 ---- ---- ---- -------- ------------ -------------------------- ------ ------- ------- -------- -------- ------------------------
 XD01 DEDR DEDR V8V9DIFF V8V9DICI     V1.01                         297*     10       1*      10        5 PATH STATS INDEX
 XD00 DEBF DEBF V8V9DIFF V8V9DICI     V1.01                         297       5       1        5
      SRC  EXPLAIN
 LABL TYPE TIME
 ---- ---- --------------------------
 XD01 C    yyyy-mm-dd-14.25.36.990000
 XD00 C    yyyy-mm-dd-14.22.43.480000
  DECLARE  CUR-V8V9DIFF-TWO CURSOR FOR
  SELECT   COLUMN_15
  FROM     V8V9DFTB
  WHERE    COLUMN_15 > 'yyyy-mm-dd-16.14.50.435571'
  FOR      FETCH ONLY
           QB PL M TB AC MT                              I  NEW  COMP P C MX LCK J P J QBLOCK TABLE    INDEX    TB AC AC J JN SC SN
      LABL BL NO E NO TY CL TABLE        INDEX           O  UJOG UJOG F F SQ MOD C R T TYPE   CREATOR  CREATOR  TY DG PG D PG PG PG
      ---- -- -- - -- -- -- ------------ --------------- -- ---- ---- - - -- --- - - - ------ -------- -------- -- -- -- - -- -- --
      XD01  1  1 0  1 I * 0 V8V9DFTB    *V8V9DFTB_INDEX3 Y  NNNN NNNN S    0  IS 0     SELECT V8V9DIFF V8V9DIFF T   0  0 0  0  0  0
      XD00  1  1 0  1 I   1 V8V9DFTB     V8V9DFTB_INDEX1 Y  NNNN NNNN S    0  IS 0     SELECT V8V9DIFF V8V9DIFF T   0  0 0  0  0  0
           P CORR GROUP  W OPT  HINT P PA
      LABL M NAME MEMBER O HINT USED A QB
      ---- - ---- ------ - ---- ---- - --
      XD01                              0
      XD00                              0
 ____________________________________________________________________________________________________________________________________
 TABLES REFERENCED DURING EXPLAIN
0     TABLE                PCT  PCT                     E L FREE  PCT BUFFER      SEG
 LABL NAME               PAGES COMP     CARDF   NPAGESF S R PAGE FREE POOL     C SIZE PARTS  NACTIVEF STATSTIME
 ---- ------------------ ----- ---- --------- --------- - - ---- ---- -------- - ---- ----- --------- --------------------------
 XD01 V8V9DFTB          *   -1*  -1*       -1*       -1 E A    0    0 BP0          16     0*       -1 0001-01-01-00.00.00.000000
 XD00 V8V9DFTB              99    0      2036       255 E A    0    0 BP0          16     0       360 2008-08-11-16.14.53.739630
           COLUMN             COL COLUMN     COL         COLUMN             COL
      LABL NAME               NUM TYPE       LEN SCALE N NAME               NUM HIGH2KEY         LOW2KEY           COLCARDF
      ---- ------------------ --- -------- ----- ----- - ------------------ --- ---------------- ---------------- ---------
      XD01 KEY1_INTEGER_SHORT   1 INTEGER      4     0 N KEY1_INTEGER_SHORT   1*2020202020202020*2020202020202020*       -1
      XD01 COLUMN_2_SML_SHORT   2 SMALLINT     2     0 N COLUMN_2_SML_SHORT   2*2020202020202020*2020202020202020*       -1
      XD01 COLUMN_3_CHAR_12     3 CHAR        12     0 N COLUMN_3_CHAR_12     3*2020202020202020*2020202020202020*       -1
      XD01 COLUMN_4             4 CHAR         7     0 N COLUMN_4             4*2020202020202020*2020202020202020*       -1
      XD01 COLUMN_5             5 CHAR         4     0 N COLUMN_5             5*2020202020202020*2020202020202020*       -1
      XD01 COLUMN_6_VARCHAR55   6 VARCHAR     55     0 N COLUMN_6_VARCHAR55   6*2020202020202020*2020202020202020*       -1
      XD01 COLUMN_9             7 SMALLINT     2     0 N COLUMN_9             7*2020202020202020*2020202020202020*       -1
      XD01 COLUMN_10            8 INTEGER      4     0 N COLUMN_10            8*2020202020202020*2020202020202020*       -1
      XD01 COLUMN_11            9 FLOAT        4     0 N COLUMN_11            9*2020202020202020*2020202020202020*       -1
      XD01 COLUMN_12           10 FLOAT        8     0 N COLUMN_12           10*2020202020202020*2020202020202020*       -1
      XD01 COLUMN_13           11 DATE         4     0 N COLUMN_13           11*2020202020202020*2020202020202020*       -1
      XD01 COLUMN_14           12 TIME         3     0 N COLUMN_14           12*2020202020202020*2020202020202020*       -1
1'BATCH COMPARE REPORT DEBF TO DEDR V8V9DIFF PG'                                                                               3
0     XD01 COLUMN_15           13 TIMESTMP    10     0 N COLUMN_15           13*2020202020202020*2020202020202020*       -1
      XD01 COLUMN_16           14 VARCHAR     30     0 N COLUMN_16           14*2020202020202020*2020202020202020*       -1
      XD01 COLUMN_17           15 INTEGER      4     0 N COLUMN_17           15*2020202020202020*2020202020202020*       -1
      XD01 COLUMN_18           16 CHAR        20     0 Y COLUMN_18           16*2020202020202020*2020202020202020*       -1
      XD01 COLUMN_19           17 CHAR        24     0 Y COLUMN_19           17*2020202020202020*2020202020202020*       -1
      XD01 COLUMN_20           18 INTEGER      4     0 Y COLUMN_20           18*2020202020202020*2020202020202020*       -1
      XD01 COLUMN_21           19 TIMESTMP    10     0 Y COLUMN_21           19*2020202020202020*2020202020202020*       -1
      XD00 KEY1_INTEGER_SHORT   1 INTEGER      4     0 N KEY1_INTEGER_SHORT   1 801BCEAE20202020 8012F7AC20202020      2036
      XD00 COLUMN_2_SML_SHORT   2 SMALLINT     2     0 N COLUMN_2_SML_SHORT   2 FC38202020202020 01BA202020202020       213
      XD00 COLUMN_3_CHAR_12     3 CHAR        12     0 N COLUMN_3_CHAR_12     3 40C1C1C2D5F0F0F0 40C1C1C2D5F0F0F0       614
      XD00 COLUMN_4             4 CHAR         7     0 N COLUMN_4             4 F1F6F6F3F0F6F420 F0F0F1F4F2F1F320       744
      XD00 COLUMN_5             5 CHAR         4     0 N COLUMN_5             5 F9F5F5F920202020 F0F0F7F220202020       752
      XD00 COLUMN_6_VARCHAR55   6 VARCHAR     55     0 N COLUMN_6_VARCHAR55   6 F4F3F7F6F5F94040 C3D6D4D7D3C1C9D5        30
      XD00 COLUMN_9             7 SMALLINT     2     0 N COLUMN_9             7 8000202020202020 8000202020202020         1
      XD00 COLUMN_10            8 INTEGER      4     0 N COLUMN_10            8 8000000020202020 8000000020202020         1
      XD00 COLUMN_11            9 FLOAT        4     0 N COLUMN_11            9 8000000020202020 8000000020202020         1
      XD00 COLUMN_12           10 FLOAT        8     0 N COLUMN_12           10 8000000000000000 8000000000000000         1
      XD00 COLUMN_13           11 DATE         4     0 N COLUMN_13           11 2008081120202020 2008081120202020         1
      XD00 COLUMN_14           12 TIME         3     0 N COLUMN_14           12 1614502020202020 1614502020202020         1
      XD00 COLUMN_15           13 TIMESTMP    10     0 N COLUMN_15           13 2008081116145077 2008081116145043      2036
      XD00 COLUMN_16           14 VARCHAR     30     0 N COLUMN_16           14 0000000000009784 0000000000000000      2036
      XD00 COLUMN_17           15 INTEGER      4     0 N COLUMN_17           15 7940604020202020 55E540D520202020        18
      XD00 COLUMN_18           16 CHAR        20     0 Y COLUMN_18           16 00F9F740D9C5C64B 0040404040404040        24
      XD00 COLUMN_19           17 CHAR        24     0 Y COLUMN_19           17 00FF45E361F1F2F7 000034E361F0F5F9      1664
      XD00 COLUMN_20           18 INTEGER      4     0 Y COLUMN_20           18 00EB40D3C1202020 004140D3E8202020      1184
      XD00 COLUMN_21           19 TIMESTMP    10     0 Y COLUMN_21           19 FF20202020202020 FF20202020202020         1
           INDEX              U C C                BUFFER       FIRST      FULL   CLUSTER
      LABL NAME               R G D     NLEAF NLVL POOL       KEYCARD   KEYCARD     RATIO
      ---- ------------------ - - - --------- ---- -------- --------- --------- ---------
      XD01 V8V9DFTB_INDEX3   *U Y*Y*       -1*  -1 BP0     *       -1*       -1* 0.000000
      XD00 V8V9DFTB_INDEX1    U N Y        10    2 BP0           2036      2036  1.000000
      XD00 V8V9DFTB_INDEX2    D N N        35    2 BP0            213      2036  0.811886
      XD00 V8V9DFTB_INDEX3    D Y N        79    2 BP0              1      2036  0.811886
      XD00 V8V9DFTB_INDEX4    D N Y         6    2 BP0            614       614  1.000000
                KEY           CO CO   INDEX
           LABL COLUMN        NO SQ O NAME
           ---- ------------ --- -- - ------------------
           XD01 COLUMN_9       7  1 A V8V9DFTB_INDEX3
           XD01 COLUMN_2_SML   2  2 A V8V9DFTB_INDEX3
           XD01 COLUMN_3_CHA   3  3 A V8V9DFTB_INDEX3
           XD01 COLUMN_4       4  4 A V8V9DFTB_INDEX3
           XD01 COLUMN_5       5  5 A V8V9DFTB_INDEX3
           XD01 KEY1_INTEGER   1  6 A V8V9DFTB_INDEX3
           XD01 COLUMN_10      8  7 A V8V9DFTB_INDEX3
           XD01 COLUMN_11      9  8 A V8V9DFTB_INDEX3
           XD01 COLUMN_12     10  9 A V8V9DFTB_INDEX3
           XD01 COLUMN_13     11 10 A V8V9DFTB_INDEX3
           XD01 COLUMN_14     12 11 A V8V9DFTB_INDEX3
           XD01 COLUMN_15     13 12 A V8V9DFTB_INDEX3
           XD01 COLUMN_17     15 13 A V8V9DFTB_INDEX3
           XD01 COLUMN_18     16 14 A V8V9DFTB_INDEX3
           XD01 COLUMN_19     17 15 A V8V9DFTB_INDEX3
           XD01 COLUMN_20     18 16 A V8V9DFTB_INDEX3
           XD01 COLUMN_21     19 17 A V8V9DFTB_INDEX3
           XD00 COLUMN_15     13  1 A V8V9DFTB_INDEX1
           XD00 COLUMN_2_SML   2  1 A V8V9DFTB_INDEX2
           XD00 COLUMN_3_CHA   3  2 A V8V9DFTB_INDEX2
           XD00 KEY1_INTEGER   1  3 A V8V9DFTB_INDEX2
1'BATCH COMPARE REPORT DEBF TO DEDR V8V9DIFF PG'                                                                               4
0          XD00 COLUMN_17     15  4 A V8V9DFTB_INDEX2
           XD00 COLUMN_19     17  5 A V8V9DFTB_INDEX2
           XD00 COLUMN_20     18  6 A V8V9DFTB_INDEX2
           XD00 COLUMN_9       7  1 A V8V9DFTB_INDEX3
           XD00 COLUMN_2_SML   2  2 A V8V9DFTB_INDEX3
           XD00 COLUMN_3_CHA   3  3 A V8V9DFTB_INDEX3
           XD00 COLUMN_4       4  4 A V8V9DFTB_INDEX3
           XD00 COLUMN_5       5  5 A V8V9DFTB_INDEX3
           XD00 KEY1_INTEGER   1  6 A V8V9DFTB_INDEX3
           XD00 COLUMN_10      8  7 A V8V9DFTB_INDEX3
           XD00 COLUMN_11      9  8 A V8V9DFTB_INDEX3
           XD00 COLUMN_12     10  9 A V8V9DFTB_INDEX3
           XD00 COLUMN_13     11 10 A V8V9DFTB_INDEX3
           XD00 COLUMN_14     12 11 A V8V9DFTB_INDEX3
           XD00 COLUMN_15     13 12 A V8V9DFTB_INDEX3
           XD00 COLUMN_17     15 13 A V8V9DFTB_INDEX3
           XD00 COLUMN_18     16 14 A V8V9DFTB_INDEX3
           XD00 COLUMN_19     17 15 A V8V9DFTB_INDEX3
           XD00 COLUMN_20     18 16 A V8V9DFTB_INDEX3
           XD00 COLUMN_21     19 17 A V8V9DFTB_INDEX3
           XD00 COLUMN_3_CHA   3  1 A V8V9DFTB_INDEX4
           COLUMN                 COLUMN                                       COLUMN
      LABL NAME         FREQUENCY VALUE                            T     CARDF GROUP
      ---- ------------ --------- -------------------------------- - --------- ----------------
      XD00 COLUMN_2_SML  0.232318 8000                             F        -1
      XD00 COLUMN_2_SML  0.033399 A328                             F        -1
      XD00 COLUMN_2_SML  0.018173 AEE0                             F        -1
      XD00 COLUMN_2_SML  0.017682 04D0                             F        -1
      XD00 COLUMN_2_SML  0.012279 A710                             F        -1
      XD00 COLUMN_2_SML  0.012279 B070                             F        -1
      XD00 COLUMN_2_SML  0.010314 A260                             F        -1
      XD00 COLUMN_2_SML  0.009823 8ED8                             F        -1
      XD00 COLUMN_2_SML  0.009332 90B3                             F        -1
      XD00 COLUMN_2_SML  0.008841 B520                             F        -1
      XD00 COLUMN_3_CHA  0.001965 40C1C1C2D5F0F0F0F0F4F6F5         F        -1
      XD00 COLUMN_3_CHA  0.001965 40C1C1C2D5F0F0F0F0F4F6F8         F        -1
      XD00 COLUMN_3_CHA  0.001965 40C1C1C2D5F0F0F0F0F4F7F1         F        -1
      XD00 COLUMN_3_CHA  0.001965 40C1C1C2D5F0F0F0F0F4F7F4         F        -1
      XD00 COLUMN_3_CHA  0.001965 40C1C1C2D5F0F0F0F0F4F7F7         F        -1
      XD00 COLUMN_3_CHA  0.001965 40C1C1C2D5F0F0F0F0F4F8F0         F        -1
      XD00 COLUMN_3_CHA  0.001965 40C1C1C2D5F0F0F0F0F4F8F3         F        -1
      XD00 COLUMN_3_CHA  0.001965 40C1C1C2D5F0F0F0F0F4F8F6         F        -1
      XD00 COLUMN_3_CHA  0.001965 40C1C1C2D5F0F0F0F0F4F8F9         F        -1
      XD00 COLUMN_3_CHA  0.001965 40C1C1C2D5F0F0F0F0F4F9F2         F        -1
      XD00 COLUMN_9      1.000000 8000                             F        -1
 ____________________________________________________________________________________________________________________________________
 REPORT SUMMARY
0STATEMENTS WITH DIFFERENCES      3
 TOTAL STATEMENTS                 3
 TOTAL TABLES                     1

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*