Let's say the table is partitioned by Month_Key and I execute a simple

SELECT Columns FROM PartitionedTable WHERE Month_Key=201701.

I am wondering whether there are any disadvantages regarding SQL query performance when storing partitions for a partitioned table in one filegroup vs. multiple file groups?

Then, let's say that I execute multiple queries at the same time, querying different Month_Key values. Would the total execution time be lower if the table partitions are stored in multiple file groups vs. one file group?

  • Can you clarify why you are partitioning the table in the first place? – Joe Obbish Aug 7 '17 at 15:59

At least for SQL Server, using multiple files or multiple filegroups on the same set of disks should have no significant impact on performance.

If you have separate drives mounted and want to spread the IO across them, then multiple files or multiple filegroups can help you do that. But that's a separate issue.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.