asked
Can you partiton empty table?
I’m using CTE to create an orders table from the items table. The final count for the orders table is around 120 million. It is taking about 2 hours for the whole process. Can partitioning the table help reduce the completion time? If so, can I partition an empty table by order year and then insert into the orders table from the CTE. Or will I need to create a partition on the items table since the cte is rolled up from the items table? Thanks in advance for the help.
Yes, you absolutely can create a partition on an empty table. Then the load process is whatever process you use to load the data.
14 People are following this question.
