oracle中的B-TREE索引
摘要:
在字段值情况不同的条件下测试B-TREE索引效率清空共享池和数据缓冲区alter system flush shared_pool;alter system flush buffer_cache;创建测试表create table ann_t1 as select object_id,object_name from dba_objects;create table ann_t2 as select mode(object_id,2) objectid,object_name from dba_objects;创建索引,默认为B树索引create index idx_t1_objectid o 阅读全文
posted @ 2013-10-08 17:41 AssassinAnn 阅读(320) 评论(0) 推荐(0) 编辑