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?
Showing posts with label faillfactor. Show all posts
Showing posts with label faillfactor. Show all posts
Tuesday, March 27, 2012
Default fillfactor for indexes
Labels:
database,
default,
faillfactor,
fillfactor,
indexes,
microsoft,
mysql,
nonclustered,
oracle,
rebuilding,
server,
sql,
table
Subscribe to:
Posts (Atom)