Filegroup in SQL Server 2005
I have very large tables (5,000,000 records each year) which are frequently joined to each other, should I put each of them on a different filegroup? what about their indexes which are used in join conditions?
Software/Hardware used:
Software/Hardware used:
ASKED:
January 1, 2008 4:53 AM
UPDATED:
January 1, 2008 8:17 PM
Answer Wiki:
Probably, depending on how you can lay out the physical files that make up the file groups.
If you can put each file group on it's own hard drive array then definetly as you will see a lot of benefit.
Index should always be in there own filegroup.
Are these tables archived versions of the same table? If so then you might consider a single partitioned table for all the years so that the joins aren't needed at all.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
