Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Handling of indexes
Message
 
 
À
22/02/2010 16:58:52
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01450358
Message ID:
01450448
Vues:
77
This message has been marked as a message which has helped to the initial question of the thread.
A separate filegroup for the indexes could be beneficial. I don't see any downside to it besides that you have to remember to create indexes on the correct filegroup.

>By default, all setups I have been done on several applications were putting all the indexes in their default settings. Thus, they were part of the MDF file. Recently, on a client's application as well as in here, we had the need to create combo indexes. So, while having created them, we assigned them in their own files. So, basically, they are located in an NDF file.
>
>Now, considering the fact that whenever a recovery of a database is needed, I have everything needed in the application to recreate all the indexes, I found this approach to be quite nice. Basically, this allows the mdf to be smaller for every backup synchronizations I am doing. So, I am wondering, considering a 10 GB MDF file, which contains all the indexes which were created at first, would I be better to assign them in their own files. So, by doing that, the MDF will become smaller and I won't have to download them for every backup I am doing.
>
>I expect the MDF to shrink to about 8 GB if I would separate the index from it.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform