Fill Factor Value is Same as Default

Each database has a default fill factor, and each index in a database can either have a custom fill factor set or use the default. This warning has been raised because the index fill factor is not the same as the current database default.

Although not an immediate problem in its own right, if the database default is changed and all indexes rebuilt, there may be the expectation that this index will take on the new fill factor. So consider whether this index truly does need its fill factor explicitly set, and more specifically, whether it needs it set to the same as the database default.

Suggested Action

Remove the explicit setting and configure the fill factor to be the database default.

Any suggestion from Aireforge should be thoroughly tested before being implemented into production.