Fast full index scan 浅析 Fast Full Index ScanA fast full index scan is a full index scan in which the database accesses the data in the index itself without accessing the table, and the databas

高效的SQL（Function-based Indexes函数、运算优化思路） ①Function-based Indexes situations1、  UPPER function  http://www.oracle-base.com/articles/8i/function-based-indexes.php2、  col1+col2 ②experime

高效的SQL（bitmap indexes optimize low cardinality columns）  ①Bitmap indexes situations1、 indexed columns have low cardinality2、 redo-only or not subject to significant modification by DML3、da

Composite Indexes（最佳前导列的选择） 一、前导列是否有序对composite indexes的影响大 1、创建表t1(x,y)  x有序列，y随意列doudou@TEST> begin  2  for i in 1.. 1000000 loop  3  insert into t1 values (i,to_char(dbms_random.rando

'596849' reverse key index is ?（转载asktom） 本文小实验来源ASKTOM网站，感谢http://asktom.oracle.comdoudou@TEST> create table t (x number, y varchar2(10));doudou@TEST> insert into t values(596849 ,'596849')

高效的SQL（index skip scan使用条件） Index Skip ScanIndex skip scans improve index scans by nonprefix columns. Often, scanning index blocks is faster than scanning table data blocks.Skip scanning lets

高效的SQL( clustering factor减少COST) 1、创建样表cluster_factor(x有序列，y随意列);实验表cluster01(low)、cluster02(high)doudou@TEST> create table cluster_factor (x int, y int);Table created.doudou@TEST> begin

高效的SQL（Index unique scan最优化） 1、    实验表test 唯一约束ID，test1主键 ID 。（唯一约束与主键会自动创建索引）。另外建立一张没有约束的表test2与test1数据相同，但是没有主键约束。Test表doudou@TEST> desc test Name

高效的SQL（index range scan优化排序） 一、     实验表表的结构、内容、索引(Data is returned in the ascending order of index columns. Multiple rows with identical values are sorted in ascending order by rowid.)doudou@T

高效的SQL（隐式转换导致不走索引） 1、创建实验表doudou,索引创建在varchar2类型的id列上，索引名DOUDOU_INDEXdoudou@TEST> select count(*) from doudou;   COUNT(*)----------      1000doudou@TEST> select index_name,table_owner,

高效的SQL（Index-Organized Tables优化精确查询和范围查询） 本文3部分1、创建索引组织表（PCTTHRESHOLD和OVERFLOW的意义）2、索引组织表中删除大量数据及重建索引（不是index rebuild而是alter table tablenamesmove online）3、索引组织表查询优化（2种情况：3-1、exact match