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?
Tuesday, March 27, 2012
Default fillfactor for indexes
Labels:
database,
default,
faillfactor,
fillfactor,
indexes,
microsoft,
mysql,
nonclustered,
oracle,
rebuilding,
server,
sql,
table
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment