Forum Discussion
SLong100493
Sep 23, 2022Copper Contributor
Partitions - How to delete data and reload from and into a middle partition
We have a large data table that is partitioned by years ranging from 2016 through 2022. Due to a discrepancy found from the external entity, the existing 2020 data needs to be removed and reloaded. ...
SLong100493
Oct 04, 2022Copper Contributor
In the end, one of my mistakes in the development environment that I corrected when I implemented in production was to use a DELETE to empty the partition instead of a TRUNCATE TABLE <name> WITH PARTITIONS (#). Truncate was the correct choice for the intended performance and amount data.