优化分析

优化分析de 命令：set autotrce traceonly explain

Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE (Cost=7 Card=1 Bytes=200)
   1    0   TABLE ACCESS (BY INDEX ROWID) OF 'OPERATIONDEFINE' (Cost=1
           Card=1 Bytes=13)

   2    1     INDEX (UNIQUE SCAN) OF 'SYS_C0011859' (UNIQUE)
   3    0   TABLE ACCESS (BY INDEX ROWID) OF 'CONNECTMODE' (Cost=1 Car
          d=1 Bytes=11)

   4    3     INDEX (UNIQUE SCAN) OF 'SYS_C0011482' (UNIQUE)
   5    0   TABLE ACCESS (BY INDEX ROWID) OF 'CUSTOMERTYPE' (Cost=1 Ca
          rd=1 Bytes=9)

   6    5     INDEX (UNIQUE SCAN) OF 'SYS_C006563' (UNIQUE)
   7    0   TABLE ACCESS (BY INDEX ROWID) OF 'OFFICE' (Cost=1 Card=1 B
          ytes=15)

   8    7     INDEX (UNIQUE SCAN) OF 'SYS_C0011848' (UNIQUE)
   9    0   TABLE ACCESS (BY INDEX ROWID) OF 'BUSINESSSPOT' (Cost=1 Ca
          rd=1 Bytes=18)

  10    9     INDEX (UNIQUE SCAN) OF 'SYS_C006496' (UNIQUE)
  11    0   TABLE ACCESS (BY INDEX ROWID) OF 'OPERATOR' (Cost=2 Card=1
           Bytes=19)

  12   11     INDEX (UNIQUE SCAN) OF 'SYS_C007464' (UNIQUE) (Cost=1 Ca
          rd=1)

  13    0   COUNT (STOPKEY)
  14   13     TABLE ACCESS (BY INDEX ROWID) OF 'HISTORYINPUTUSERACCOUN
          T' (Cost=1 Card=1 Bytes=22)

  15   14       INDEX (RANGE SCAN) OF 'INX_HISTORYINPUTUSERACCOUNT_G'
          (NON-UNIQUE) (Cost=1 Card=1)

  16    0   TABLE ACCESS (BY INDEX ROWID) OF 'PAYSTRATEGY' (Cost=2 Car
          d=1 Bytes=30)

  17   16     INDEX (UNIQUE SCAN) OF 'PK_PAYSTRATEGY' (UNIQUE) (Cost=1
           Card=1)

  18    0   TABLE ACCESS (BY INDEX ROWID) OF 'OPERATOR' (Cost=2 Card=1
           Bytes=19)

  19   18     INDEX (UNIQUE SCAN) OF 'SYS_C007464' (UNIQUE) (Cost=1 Ca
          rd=1)

  20    0   FILTER
  21   20     TABLE ACCESS (BY INDEX ROWID) OF 'HISTORYINPUTCUSTOMERIN
          FO' (Cost=2 Card=1 Bytes=92)

  22   21       NESTED LOOPS (Cost=5 Card=1 Bytes=200)
  23   22         NESTED LOOPS (Cost=3 Card=1 Bytes=108)
  24   23           TABLE ACCESS (BY INDEX ROWID) OF 'HISTORYINPUTUSER
          INFO' (Cost=1 Card=1 Bytes=65)

  25   24             INDEX (RANGE SCAN) OF 'INX_HISTORYINPUTUSERINFO_
          CMODE' (NON-UNIQUE) (Cost=1 Card=1)

  26   23           TABLE ACCESS (BY INDEX ROWID) OF 'USERTRANSACTION'
           (Cost=2 Card=1 Bytes=43)

  27   26             INDEX (UNIQUE SCAN) OF 'SYS_C007984' (UNIQUE) (C
          ost=1 Card=1)

  28   22         INDEX (RANGE SCAN) OF 'INX_HISTORYINPUTCUSTOMERINFO_
          G' (NON-UNIQUE) (Cost=1 Card=82)

  29   20     NESTED LOOPS (Cost=2 Card=1 Bytes=19)
  30   29       TABLE ACCESS (BY INDEX ROWID) OF 'BUSINESSSPOT' (Cost=
          1 Card=1 Bytes=9)

  31   30         INDEX (UNIQUE SCAN) OF 'SYS_C006496' (UNIQUE)
  32   29       TABLE ACCESS (BY INDEX ROWID) OF 'OPERATOR' (Cost=1 Ca
          rd=1 Bytes=10)

  33   32         INDEX (UNIQUE SCAN) OF 'SYS_C007464' (UNIQUE)