1 Z 2 X 3 U 4 T 5 G 6 F 7 C 8 B 9 A 1 A 2 B 3 C 4 D Oracle的索引是以平衡树的方式组织存储的:保存的是索引列的值,以及该行的rowid的一部分(文件号,块号,行号) 下面我们通过例子来了解一下: 1,create table test(id int,name varchar2(20)) insert into test values(1,'Z'); insert into test values(2,'X'); insert into test values(3,'U'); insert into test values(4,'T'); insert into test values(5,'G'); insert into test values(6,'F'); insert into test values(7,'C'); insert into test values(8,'B'); insert into test values(9,'A'); insert into test values(1,'Z'); insert into test values(2,'B'); insert into test values(3,'C'); insert into test values(4,'D'); insert into test values(5,'F'); insert into test values(6,'H'); insert into test values(7,'G'); insert into test values(8,'H'); insert into test values(8,'I'); beg
组合索引leaf 数据存储
最新推荐文章于 2021-06-27 16:10:41 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)