昨日跟原来一同事聊到index split这个话题，过去一直没关注过，今天借空闲机会学习了下，下面记录下实验的过程。 50-50 split Root block, branch block are always in 50-50 split when the block is full. If the new value of index is not maximum value of t

昨日跟原来一同事聊到index split这个话题，过去一直没关注过，今天借空闲机会学习了下，下面记录下实验的过程。 50-50 split Root block, branch block are always in 50-50 split when the block is full. If the new value of index is not maximum value of t

通常情况下当BUCTET 而当BUCTET >= 表的NUM_DISTINCT值的时候得到的是FREQUENCY（频率）直方图。 一、准备数据 SQL> create table tab(a number,b number); Table created. SQL> begin 2 for i in 1..10000 loop 3 insert into tab