Tuesday, March 27, 2012

Default fillfactor for indexes

Is there a way to change the default faillfactor for a table or its nonclustered indexes without rebuilding it?Hi Jeffrey
Fillfactor only applies when an index is being built; it is not maintained.
So changing it on an existing index wouldn't mean anything. What are you
trying to accomplish?
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jeffrey" <anonymous@.discussions.microsoft.com> wrote in message
news:0B210F3F-F1E4-4857-A60C-41867F6EB1E8@.microsoft.com...
> Is there a way to change the default faillfactor for a table or its
nonclustered indexes without rebuilding it?

No comments:

Post a Comment