DZone Database Zone
What Is the Best Value for Your Fill Factor?
The fill factor is directly related to indexing, and indexing is directly related to performance. So, for performance, your fill factor plays a very important role.
The fill factor determines the percent of each leaf-level page that will be filled with data. By default, it is 100 percent. That means all most all the space of an 8KB leaf-level page is filled with data.
No comments:
Post a Comment