eygle.com - 留言簿 - 回复留言

eygle.com - 留言簿 - 回复留言 - Powered by eYgLe.Com

返回留言簿

回复留言

留言ID:

留言原文:

To:
　　这是我的执行计划
Execution Plan
----------------------------------------------------------
0SELECT STATEMENT Optimizer=CHOOSE (Cost=6146 Card=2961 Bytes
 =68103)

10 FILTER
21 TABLE ACCESS (FULL) OF 'ERA_TRADE_INFO' (Cost=224 Card=2
 961 Bytes=68103)

31 FILTER
43 NESTED LOOPS (Cost=2 Card=1 Bytes=39)
54 NESTED LOOPS (Cost=2 Card=1 Bytes=35)
65 INDEX (UNIQUE SCAN) OF 'IDX_OPERCHANNEL' (UNIQUE)
75 TABLE ACCESS (BY INDEX ROWID) OF 'ERA_CERT_INFO' (
 Cost=1 Card=1 Bytes=29)

87 INDEX (UNIQUE SCAN) OF 'PK_ERA_CERT_INFO' (UNIQU
 E)

94 INDEX (UNIQUE SCAN) OF 'PK_ERA_CERT_USER_INFO' (UNIQ
 UE)

From: hds6400
2009.03.23 00:42