| 失效链接处理 |
|
DBA运维之索引 PDF 下载
本站整理下载：
提取码：m8ul
相关截图：
主要内容：
无索引
SQL> update i set object_id=object_id+1;
74977 rows updated.
Elapsed: 00:00:02.06
Execution Plan
----------------------------------------------------------
Plan hash value: 4254681844
---------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------------------------
| 0 |UPDATE STATEMENT | | 74977 | 366K| 299 (1)| 00:00:04 |
| 1 | UPDATE | I | | | | |
| 2 | TABLE ACCESS FULL| I | 74977 | 366K| 299 (1)| 00:00:04 |
---------------------------------------------------------------------------
Statistics
--------------------------------------------------------
106 recursive calls
82379 db block gets
2363 consistent gets
0 physical reads
25260520 redo size
841 bytes sent via SQL*Net to client
786 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
6 sorts (memory)
0 sorts (disk)
74977 rows processed
|
| Java1234官方群25： | 
|
| Java1234官方群25： | 838462530 |
苏公网安备 32061202001004号
