Operation Object Name Rows Bytes Cost Object Node In/Out PStart PStopSELECT STATEMENT Optimizer Mode=CHOOSE
SORT AGGREGATE
TABLE ACCESS BY INDEX ROWID SZRDEVUSR.TBL_ACCOUNT_DETAIL
INDEX RANGE SCAN SZRDEVUSR.IDX_ACCT_DETAIL_STOCK_TYPE
SORT AGGREGATE
FILTER
TABLE ACCESS FULL SZRDEVUSR.TBL_ACCT_FROZEN
TABLE ACCESS FULL SYS.DUAL
TABLE ACCESS FULL SYS.DUAL
NESTED LOOPS
NESTED LOOPS
NESTED LOOPS OUTER
NESTED LOOPS
VIEW SZRDEVUSR.V_STOCKTYPE
UNION-ALL
TABLE ACCESS FULL SZRDEVUSR.TBL_STOCK_TYPE
TABLE ACCESS FULL SZRDEVUSR.TBL_STOCK_TYPE
TABLE ACCESS FULL SZRDEVUSR.TBL_STOCK_TYPE
TABLE ACCESS BY INDEX ROWID SZRDEVUSR.TBL_ACCOUNT_DETAIL
INDEX RANGE SCAN SZRDEVUSR.IDX_ACCT_DETAIL_STOCK_TYPE
TABLE ACCESS BY INDEX ROWID SZRDEVUSR.TBL_ACCOUNTS
INDEX UNIQUE SCAN SZRDEVUSR.TBL_ACCOUNTS_PK
TABLE ACCESS BY INDEX ROWID SZRDEVUSR.TBL_ACCOUNTS
INDEX UNIQUE SCAN SZRDEVUSR.TBL_ACCOUNTS_PK
TABLE ACCESS BY INDEX ROWID SZRDEVUSR.TBL_CORPORATION
INDEX UNIQUE SCAN SZRDEVUSR.TBL_CORPORATION_PK
是这样的执行计划
SORT AGGREGATE
TABLE ACCESS BY INDEX ROWID SZRDEVUSR.TBL_ACCOUNT_DETAIL
INDEX RANGE SCAN SZRDEVUSR.IDX_ACCT_DETAIL_STOCK_TYPE
SORT AGGREGATE
FILTER
TABLE ACCESS FULL SZRDEVUSR.TBL_ACCT_FROZEN
TABLE ACCESS FULL SYS.DUAL
TABLE ACCESS FULL SYS.DUAL
NESTED LOOPS
NESTED LOOPS
NESTED LOOPS OUTER
NESTED LOOPS
VIEW SZRDEVUSR.V_STOCKTYPE
UNION-ALL
TABLE ACCESS FULL SZRDEVUSR.TBL_STOCK_TYPE
TABLE ACCESS FULL SZRDEVUSR.TBL_STOCK_TYPE
TABLE ACCESS FULL SZRDEVUSR.TBL_STOCK_TYPE
TABLE ACCESS BY INDEX ROWID SZRDEVUSR.TBL_ACCOUNT_DETAIL
INDEX RANGE SCAN SZRDEVUSR.IDX_ACCT_DETAIL_STOCK_TYPE
TABLE ACCESS BY INDEX ROWID SZRDEVUSR.TBL_ACCOUNTS
INDEX UNIQUE SCAN SZRDEVUSR.TBL_ACCOUNTS_PK
TABLE ACCESS BY INDEX ROWID SZRDEVUSR.TBL_ACCOUNTS
INDEX UNIQUE SCAN SZRDEVUSR.TBL_ACCOUNTS_PK
TABLE ACCESS BY INDEX ROWID SZRDEVUSR.TBL_CORPORATION
INDEX UNIQUE SCAN SZRDEVUSR.TBL_CORPORATION_PK
是这样的执行计划
我是看不懂explain plan里的那些记录.
不知道它们是什么意思.
要不你去找本TOAD的书看看吧