One of the efficient ways of improving performance is partitioning the table that allows storing data in more than one physical file. Consider a scenario where a table contains 1 million rows, when a query is executed against that it might have to scan huge #'s of rows before it returns the result. Separating data in different filegroups will help scanning all the physical files at a same time. [More]