一. 官网说明
The index clustering factor measures row order in relation to an indexed value suchas employee last name.
The more order that exists in rowstorage for this value, the lower the clustering factor.
-- row 存储的越有序,clustering factor 的值越低
index clustering factor 表示索引值有关的行的顺序 比如employee的last name.
这个值的存储的记录越有顺序,那么 clustering factor越低
The clustering factor is useful as a rough measure of thenumber of I/Os required to read an entire table by means of an index:
(1)If the clustering factor is high, then Oracle Database performs a relativelyhigh number of I/Os during a large index range scan.
The index entries point to random table blocks,
优化 集群因子概念
最新推荐文章于 2024-03-02 22:53:29 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)