Saved Bookmarks
| 1. |
What Should Be The Fill Factor For Indexes Created On Tables? |
|
Answer» Fill factor specifies a PERCENTAGE that indicates how full the Database ENGINE should make the leaf LEVEL of each INDEX PAGE during index creation or alteration. Fill factor must be an integer value from 1 to 100. The default is 0. I prefer to keep my servers default fill factor as 90. Fill factor specifies a percentage that indicates how full the Database Engine should make the leaf level of each index page during index creation or alteration. Fill factor must be an integer value from 1 to 100. The default is 0. I prefer to keep my servers default fill factor as 90. |
|