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?
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.