AssassinAnn

摘要： 在字段值情况不同的条件下测试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 阅读全文