The following are reasons to consider partitioning: If you have never performed any analysis on your datasets to see if they would benefit from partitioning, by all means do that. You should now have the skill set to ask those basic questions. The recommended file size depends on the pool type: SQL is between 100…
