请教，这些动作的解释文档在哪一章节?

显示全部楼层 · 2012-7-12 18:47:29

比如：HASH JOIN SEMI，TABLE ACCESS BY INDEX ROWID
等动作的解释，在ORACLE官方文档的哪一章哪一节？
ORACLE92。
[php]
----------------------------------------------------------------------------------------------------------
| Id| Operation
| Name
| Rows| Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT
|
| 1 | 168 |16 (7)| 00:00:01 |
|*1 |HASH JOIN SEMI
|
| 1 | 168 |16 (7)| 00:00:01 |
|*2 | TABLE ACCESS BY INDEX ROWID| ORGSUPORG | 1 |22 | 2 (0)| 00:00:01 |
| 3 |NESTED LOOPS
|
| 1 | 155 | 9 (0)| 00:00:01 |
| 4 | NESTED LOOPS
|
| 1 | 133 | 7 (0)| 00:00:01 |
| 5 |NESTED LOOPS
|
| 1 | 105 | 5 (0)| 00:00:01 |
| 6 | NESTED LOOPS
|
| 1 |93 | 4 (0)| 00:00:01 |
| 7 |NESTED LOOPS
|
| 1 |75 | 3 (0)| 00:00:01 |
| 8 | TABLE ACCESS BY INDEX ROWID| PRICEPROTECTSET | 1 |33 | 1 (0)| 00:00:01 |
|*9 |
INDEX UNIQUE SCAN | PK_PRICEPROTECTSETM | 1 | | 0 (0)| 00:00:01 |
|* 10 | TABLE ACCESS BY INDEX ROWID| PRICEPROTECTTMP | 1 |42 | 2 (0)| 00:00:01 |
|* 11 |
INDEX RANGE SCAN
| I_COLLECTDATE_TEST| 1 | | 1 (0)| 00:00:01 |
|12 |TABLE ACCESS BY INDEX ROWID | CUST
| 1 |18 | 1 (0)| 00:00:01 |
|* 13 | INDEX UNIQUE SCAN
| PK_CUST
| 1 | | 0 (0)| 00:00:01 |
|14 | TABLE ACCESS BY INDEX ROWID| PRODUCT
| 1 |12 | 1 (0)| 00:00:01 |
|* 15 |INDEX UNIQUE SCAN | PK_PRODUCTDATA| 1 | | 0 (0)| 00:00:01 |
|* 16 |TABLE ACCESS BY INDEX ROWID | CUSTORG
| 1 |28 | 2 (0)| 00:00:01 |
|* 17 | INDEX RANGE SCAN
| PK_CUSTORG
| 1 | | 1 (0)| 00:00:01 |
|* 18 | INDEX RANGE SCAN
| PK_ORGSUPORG| 1 | | 1 (0)| 00:00:01 |
|19 | VIEW
| VW_NSO_1
| 170 |2210 | 7(15)| 00:00:01 |
|* 20 |FILTER
|
| | |
|
|
|* 21 | CONNECT BY WITH FILTERING|
| | |
|
|
|* 22 |FILTER
|
| | |
|
|
|23 | COUNT
|
| | |
|
|
|* 24 |HASH JOIN
|
| 170 |5270 | 7(15)| 00:00:01 |
|* 25 | TABLE ACCESS FULL
| ORGSUPORG | 171 |3762 | 3 (0)| 00:00:01 |
|* 26 | TABLE ACCESS FULL
| ORG
| 219 |1971 | 3 (0)| 00:00:01 |
|* 27 |HASH JOIN
|
| | |
|
|
|28 | CONNECT BY PUMP
|
| | |
|
|
|29 | COUNT
|
| | |
|
|
|* 30 |HASH JOIN
|
| 170 |5270 | 7(15)| 00:00:01 |
|* 31 | TABLE ACCESS FULL
| ORGSUPORG | 171 |3762 | 3 (0)| 00:00:01 |
|* 32 | TABLE ACCESS FULL
| ORG
| 219 |1971 | 3 (0)| 00:00:01 |
|33 |COUNT
|
| | |
|
|
|* 34 | HASH JOIN
|
| 170 |5270 | 7(15)| 00:00:01 |
|* 35 |TABLE ACCESS FULL | ORGSUPORG | 171 |3762 | 3 (0)| 00:00:01 |
|* 36 |TABLE ACCESS FULL | ORG
| 219 |1971 | 3 (0)| 00:00:01 |
----------------------------------------------------------------------------------------------------------
-
[/php]

千问 · 2012-7-12 18:47:29

性能优化吧

千问 · 2012-7-12 18:47:29

http://download-west.oracle.com/ ... .920/a96533/toc.htm

千问 · 2012-7-12 18:47:29

最初由油菜发布
[B]http://download-west.oracle.com/ ... .920/a96533/toc.htm [/B]
这一章我知道，但不够详细，我需要更具体解释这些动作的在第几节。

千问 · 2012-7-12 18:47:29

最初由 ZALBB 发布
[B]
这一章我知道，但不够详细，我需要更具体解释这些动作的在第几节。 [/B]
哈哈~我也想知道~

千问 · 2012-7-12 18:47:29

最初由 ZALBB 发布
[B]
这一章我知道，但不够详细，我需要更具体解释这些动作的在第几节。 [/B]

自己翻翻不就知道了,就那么几章而已,呵呵

千问 · 2012-7-12 18:47:29

BOL上的不是很详细，看看刘易斯的CBO这本书吧，包你爽

千问 · 2012-7-12 18:47:29

不只oracle10g的有没有
B19306_01/server.102/b14211/ex_plan.htm#i19260
Using EXPLAIN PLAN

千问 · 2012-7-12 18:47:29

学习了！