Oracle High Water Mask
来源:互联网 发布:软件学校哪个好 编辑:程序博客网 时间:2024/05/17 23:57
High Water Mask(最高水位线,呵呵)以下简称HWM
delete命令不影响表自身的HWM,即表中的区块会随着数据量的增大而增大,但删除数据时,
区块并不会减少,当查询时,会按照HWM的标准去扫描表,即使使用delete将表数据清空,查询时,
依旧会扫描HWM的区块,查询速度也就和没使用delete命令之前是一样的,而truncate可以将表的
HWM重置。
999999条数据时,统计个数的执行计划
SQL>
1* select count(1) from td_count
Execution Plan
---------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE
1 0 SORT (AGGREGATE)
2 1 TABLE ACCESS (FULL) OF 'TD_COUNT'
Statistics
---------------------------------------------------------
0 recursive calls
0 db block gets
1004140 consistent gets
10008 physical reads
107380 redo size
380 bytes sent via SQL*Net to client
503 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed
/************************************************************/
执行delete删除所有数据后的执行计划
SQL>
1* select count(1) from td_count
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE
1 0 SORT (AGGREGATE)
2 1 TABLE ACCESS (FULL) OF 'TD_COUNT'
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
2004139 consistent gets
23703 physical reads
107380 redo size
380 bytes sent via SQL*Net to client
503 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed
/************************************************************/
执行truncate后的执行计划
SQL> select count(1) from td_count;
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE
1 0 SORT (AGGREGATE)
2 1 TABLE ACCESS (FULL) OF 'TD_COUNT'
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
3 consistent gets
0 physical reads
0 redo size
380 bytes sent via SQL*Net to client
503 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed
- Oracle High Water Mask
- 也说Oracle High Water Mark
- Oracle 高水位(HWM: High Water Mark)
- oracle 高水位线 high water mark
- Oracle 高水位(HWM: High Water Mark)
- Oracle 高水位(HWM: High Water Mark)
- Oracle 高水位(HWM: High Water Mark)
- Oracle Study之--Oracle High Water Mark
- Oracle的高水位线(High Water Mark)
- Oracle 高水位(HWM: High Water Mark) 说明
- Oracle段高水位(HWM, high water mark)问题
- Oracle高水位标志(high-water mark)相关概念
- Oracle 高水位(HWM: High Water Mark) 说明
- Oracle 高水位(HWM: High Water Mark) 说明
- Oracle 高水位(HWM: High Water Mark) 说明
- Oracle 高水位(HWM: High Water Mark) 说明
- Oracle 高水位(HWM: High Water Mark) 说明 .
- Oracle 高水位(HWM: High Water Mark) 说明
- warning: no newline at end of file
- 在杰普的感悟
- AIX配置时间服务器及客户机实战笔记
- Java动态代理实现
- ㄟ 无处安放的流年”︿
- Oracle High Water Mask
- 糟糕透了
- 服务器教程Server2003 DNS服务安装篇
- NT局域网内的DNS解析和配置
- RPM包安装、查询与卸载
- 网页防篡改技术追踪
- 人生必读的几本好书
- 利用UrlRewriter 实现二级域名
- C#绘图双缓冲技术总结(转)