一. B-Tree Index 原理 官网说明: No index structure can satisfy all needs, but the self-balancing B-tree index comes closest to optimizing the performance of searches on large sets of data. Each B-tree node holds multiple keys and pointers. The m…
做个小小试验,测试一下:
SQL> create table t as select object_id,object_type from all_objects;
表已创建。
SQL> create index ix_t_id on t(object_id);
索引已创建。
SQL> create bitmap index ix_t_type on t(object_type);
索引已…