G
George Potemkin
Guest
The difference between 4K and 8k will not change the number of index keys in the leaf blocks. Index compression algorithm may slightly change the storage size of these keys but not too much especially for the indexes with many non-unique keys. In other words, this difference will only double the number of the leaf blocks. It will in turn double the number of index keys in the intermediate index blocks and double their total size. Hence the number of the intermediate index blocks will be increased by 4 times. The number of the intermediate blocks in the large indexes used to be 0.1-1% of the leaf blocks. To get new level in the index tree the number of index keys should be increased by the hundreds/thousands times. IMHO, it's rather unlikely that the difference between 4K and 8k will change the number of levels in the index tree. But yes, the larger block size the smaller (slightly) total size of the indexes.
Continue reading...
Continue reading...