pctfree对 index索引在什么时候有效？

最新推荐文章于 2021-04-13 22:27:59 发布

Joycesjr

最新推荐文章于 2021-04-13 22:27:59 发布

阅读量937

点赞数

本文链接：https://blog.csdn.net/ljsjr/article/details/11094281

版权

pctfree only counts when BUILDING an index. It reserves X% of the block for subsequent
inserts into that block (inserts into the block can arise from inserts or UPDATES to the
base table).
All the pctfree does on an index is defer the splitting of an index block due to
subsequent inserts/updates AFTER the index is build. 10% is just a good "starting
point".

与表的pctfree值不同，对于索引来说，其pctfree仅仅是在create或rebuild时生效，对与后续的插入、修改之类的操作来说是无效的，pctfree的设置也仅仅是为了延缓由于insert等操作而导致的的索引块分裂。