在自增字段上建索引时不要设置小于100的填充因子

最新推荐文章于 2024-08-04 21:26:17 发布

武哥博文

最新推荐文章于 2024-08-04 21:26:17 发布

阅读量1k

点赞数

文章标签： performance insert less table each

本文链接：https://blog.csdn.net/GRANDTREE/article/details/5895445

版权

由于自增字段一般不会进行update操作而insert时新行只可能插入到记录的最后，所以设置小于100的填充因子只会浪费更多的索引空间而降低性能。

A nonzero fill factor other than 0 or 100 can be good for performance if the new data is evenly distributed throughout the table. However, if all the data is added to the end of the table, the empty space in the index pages will not be filled. For example, if the index key column is an IDENTITY column, the key for new rows is always increasing and the index rows are logically added to the end of the index. If existing rows will be updated with data that lengthens the size of the rows, use a fill factor of less than 100. The extra bytes on each page will help to minimize page splits caused by extra length in the rows.

参看：

http://msdn.microsoft.com/en-us/library/ms177459.aspx