优化分析

roygbip

浏览: 19885 次

最近访客更多访客>>

helenxiao520

博主相关

博客

微博

相册

留言

关于我

文章分类

全部博客 (5)

社区版块

存档分类

Access Office C C++C#

优化分析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)

分享到：