I have a big table which is currently partitioned on a column called SupplierName. We get new data every week, for each supplier, and inserting data into this massive table takes a long time. Currently, we drop indexes, load data and then recreate indexes.

If I could further partition data under each Supplier then I could just switch partitions instead of loading data