Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Clustering and fillfactor
Message
De
05/11/1999 08:54:39
 
 
À
04/11/1999 08:33:13
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Divers
Thread ID:
00285420
Message ID:
00287426
Vues:
22
For an empty table, the fill factor will have to effect. Remember that the fillfactor determines how full to create the leaf nodes of the index. Also remember that SQL Server does not dynamically maintain the fill factor.

Given that if you were to build an index on the empty table, it would consist of one page, the root.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform