cluster factor(聚簇因子值)计算
来源:互联网 发布:淘宝售假申诉包成功 编辑:程序博客网 时间:2024/05/16 05:21
SQL> drop table t1 purge;Table dropped.create table t1(n1 number, v2 varchar2(3500), v3 varchar2(3500) );Table created.SQL> create sequence seq001 start with 1;Sequence created.SQL> insert into t1 values(seq001.nextval,lpad('a',3400,'x'),lpad('a',3400,'x'));1 row created.SQL> l 1* insert into t1 values(seq001.nextval,lpad('a',3400,'x'),lpad('a',3400,'x'))SQL> /1 row created.SQL> /1 row created.SQL> /1 row created.SQL> /1 row created.SQL> /1 row created.SQL> /1 row created.SQL> /1 row created.SQL> commit;Commit complete.SQL> select count(1) from t1; COUNT(1)---------- 8create index idx_t1_n1 on t1(n1); SQL> exec dbms_stats.gather_table_stats('AIKI','T1',cascade=>true,method_opt=>'for all indexed columns size 1',estimate_percent=>100); Index Tree Leaf Distinct Number Leaf Blocks Data Blocks Cluster Global User Sample DateName Unique Level Blks Keys of Rows Per Key Per Key Factor Stats Stats Size MM-DD-YYYY--------------- --------- ----- ---- -------------- -------------- ----------- ----------- ------------ ------ ------ -------------- ----------IDX_T1_N1 NONUNIQUE 0 1 8 8 1 1 8 YES NO 8 05-14-2014SQL> select DBMS_ROWID.ROWID_ROW_NUMBER(rowid),dbms_rowid.rowid_block_number(rowid) from t1;DBMS_ROWID.ROWID_ROW_NUMBER(ROWID) DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)---------------------------------- ------------------------------------ 0 37555 0 37556 0 37557 0 37558 0 37559 0 37563 0 37564 0 37565 SQL> drop table t2 purge;SQL> SQL> create table t2 ( n1 number, v2 varchar2(4000),v3 varchar2(4000) ); SQL> insert into t2 values(1,'a','c');1 row created.SQL> /1 row created.SQL> /1 row created.SQL> /1 row created.SQL> /1 row created.SQL> /1 row created.SQL> /1 row created.SQL> /1 row created.SQL> commit;Commit complete.SQL> create index idx_t2_n1 on t2(n1);Index created.SQL> exec dbms_stats.gather_table_stats('AIKI','T2',cascade=>true,method_opt=>'for all indexed columns size 1',estimate_percent=>100);PL/SQL procedure successfully completed.Index Tree Leaf Distinct Number Leaf Blocks Data Blocks Cluster Global User Sample DateName Unique Level Blks Keys of Rows Per Key Per Key Factor Stats Stats Size MM-DD-YYYY--------------- --------- ----- ---- -------------- -------------- ----------- ----------- ------------ ------ ------ -------------- ----------IDX_T2_N1 NONUNIQUE 0 1 1 8 1 1 1 YES NO 8 05-14-2014SQL> select DBMS_ROWID.ROWID_ROW_NUMBER(rowid),dbms_rowid.rowid_block_number(rowid) from t2;DBMS_ROWID.ROWID_ROW_NUMBER(ROWID) DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)---------------------------------- ------------------------------------ 0 37580 1 37580 2 37580 3 37580 4 37580 5 37580 6 37580 7 37580
可以看到:cluster factor 的值等于索引指向的表块的差异值+1
第1个例子的表块共有8个块,cluster factor的值:8-1+1=8
第2个例子的表块共有1个块,cluster factor的值:1-1+1=1
0 0
- cluster factor(聚簇因子值)计算
- Oracle indexclustering factor 索引聚簇因子
- Oracle 聚簇因子(Clustering factor)
- Oracle 聚簇因子(Clustering factor)
- Oracle 聚簇因子(Clustering factor)
- Oracle聚簇因子(clustering factor)
- Oracle 聚簇因子(Clustering factor)
- factor因子
- 因子Factor
- 一个执行计划异常变更的案例 - 外传之聚簇因子(Clustering Factor)
- Oracle 聚簇因子(Clustering factor)及一次性能优化诊断
- 拉伸因子(streth factor)
- 1、factor()因子的使用
- R语言之因子(factor)
- 因子(factor)的研究
- R语言中因子(factor)转换成数值型(numeric)的问题
- R语言中因子(factor)转换成数值型(numeric)的问题
- 2008 SCI 影响因子(Impact Factor)
- 避免Java应用中NullPointerException的技巧和最佳实践
- MFC创建快捷菜单(右键菜单)
- List分类
- 在Linux环境下使用TCP的keepalive机制
- java变量,初始化快,构造函数的执行顺序
- cluster factor(聚簇因子值)计算
- DAVINCI DM3730开发攻略——xload-1.51移植
- Android视图绘制流程完全解析,带你一步步深入了解View(二)
- 第六讲 ASP.NET系统对象和状态管理(五)
- JDK, JRE 和JVM的区别
- xcode 5.1 删掉Images.xcassets后iphone5屏变为,320*480
- 关于jdbc的源码解析 DriverManager 和 Driver的加载
- 实战Linux Bluetooth编程(二) BlueZ简介
- sql server2012附加数据库问题