Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Handling of indexes
Message
 
 
To
22/02/2010 16:58:52
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01450358
Message ID:
01450448
Views:
76
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform