I need to split tables into multiple file groups. My queries contains join between these tables that will be in different file groups. Does this cause bad performance on my queries?
Asked
Active
Viewed 32 times
-2
-
1"I need to split tables into multiple file groups." why? – David Browne - Microsoft Apr 14 '22 at 20:41
-
2*Does this cause bad performance on my queries*, No. Although no one is in a better postition to test it than you are. – Stu Apr 14 '22 at 20:43
-
@DavidBrowne-Microsoft Some tables are archive – ahmad valipour Apr 14 '22 at 21:01
1 Answers
1
My queries contains join between these tables that will be in different file groups. Does this cause bad performance on my queries?
No. If you split a database into two separate filegroups on the same disk, you should see no material performance difference. Obviously if you put one of these filegroups on a slower disk queries could be impacted.
David Browne - Microsoft
- 80,331
- 6
- 39
- 67