We have a table that is currently partitioned on a date column. The data has been copied to a warehouse and we would like to delete the data from the table since we do not need two copies. We are planning on just dropping the partitions instead of running delete statements. Are there any gotchas that we need to be aware of before moving forward with this strategy?
Thanks in advance.