Fillfactor fill factor setting policy

Source: Internet
Author: User

The fillfactor percentage is only used when an index is created.

General fill factor setting policies:
The more data changes, the smaller the fill factor.
The smaller the data changes, the larger the fill factor. For tables with no data changes, set the fill factor to 100.

When creating an index, you can specify a fill factor to set aside additional gaps and retain a certain percentage of space on each leaf page of the index, it can expand the data storage capacity of tables in the future and reduce the possibility of page splitting. The fill factor value is a percentage value from 0 to 100, which specifies the proportion of data pages to be filled after the index is created. When the value is 100, the page will be filled up, and the storage space reserved is the minimum. This setting is used only when data is not changed (for example, in a read-only table. The smaller the value, the larger the free space on the data page. This reduces the need for splitting data pages during the index growth process, but requires more storage space. This setting is more appropriate when data in the table is changed.

The fill factor option is provided to fine tune the performance. However, the default fill factor for the server range specified by the sp_configure system stored procedure is the best choice in most cases.

It indicates that even for an application that targets many insert and update operationsProgramGenerally, the number of database reads exceeds 5 to 10 times the number of database writes. Therefore, specifying a fill factor different from the default setting reduces the read performance of the database, and the decrease is inversely proportional to the value of the fill factor setting. For example, when the fill factor value is 50%, the read performance of the database will be twice as low.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.