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?