执行计划的时间

11 |

0 | 2008-1-18 12:54:00 | 显示全部楼层 |阅读模式

这个执行计划的cost为58961， Time 为00:11:48
是否可以说明这个sql的用时为11秒48
如果另一个sql的Time 值为10秒，是否意味10s的将执行的快？
Elapsed: 00:00:29.54
Execution Plan
----------------------------------------------------------
Plan hash value: 862233996
--------------------------------------------------------------------------------
-----------------------------------
| Id| Operation
| Name
| Rows| Byte
s |TempSpc| Cost (%CPU)| Time |
--------------------------------------------------------------------------------
-----------------------------------
| 0 | SELECT STATEMENT
|
|1145K|9
5M| | 58961 (1)| 00:11:48 |
| 1 |SORT ORDER BY
|
|1145K|9
5M| 221M| 58961 (1)| 00:11:48 |
|*2 | VIEW
|
|1145K|9
5M| | 35834 (1)| 00:07:11 |
|*3 |WINDOW NOSORT STOPKEY
|
|1145K| 11
2M| | 35834 (1)| 00:07:11 |
| 4 | SORT GROUP BY
|
|1145K| 11
2M| 263M| 35834 (1)| 00:07:11 |
| 5 |TABLE ACCESS BY INDEX ROWID| WBXLOGTABLE4
| 265K|2
0M| |6649 (1)| 00:01:20 |
| 6 | NESTED LOOPS
|
|1145K| 11
2M| |8808 (1)| 00:01:46 |
| 7 |TABLE ACCESS BY INDEX ROWID| WBXLOGSTOREDIR| 4 |9
6 | | 5 (0)| 00:00:01 |
|*8 | INDEX RANGE SCAN
| IDX_WBXLOGSTOREDIR_SD | 4 |
| | 1 (0)| 00:00:01 |
|*9 |INDEX RANGE SCAN | PK_WBXLOGTABLE4 | 265K|
| | 718 (2)| 00:00:09 |
--------------------------------------------------------------------------------
-----------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------
2 - filter("ROWN">=1 AND "ROWN"<1002)
3 - filter(ROW_NUMBER() OVER ( ORDER BY "SITE_NAME")<1002)
8 - access("WSNAME"='jsj2ws001' AND "LOGDATE"='Oct10')
9 - access("RPATH_IDX"="SEQUENCENUMBER")

Statistics
----------------------------------------------------------
117recursive calls

0db block gets
20761consistent gets
20702physical reads

0redo size
38325bytes sent via SQL*Net to client
1111bytes received via SQL*Net from client
68SQL*Net roundtrips to/from client
12sorts (memory)

0sorts (disk)
1001rows processed

使用道具举报

返回列表发新帖

千问

主题	0 回帖	4882万积分

论坛元老

Rank: 8 Rank: 8

积分: 48824836

回复楼主返回列表

问答

热门排行