Sample Header Ad - 728x90

Is it possible to add a column to a partition in a partitioned table?

0 votes
1 answer
991 views
I have a large partitioned table of 16 billion plus records. I am currently updating one of the columns to NULL using the partition number. The process is cumbersome in that it takes a lot of time to complete the operation. One of the partitions of 70 GB took 11 hours to complete the update. So my question is, is it possible to create a column within a partition so that I can use it to do the update in a faster way? Ideally I'd like to create the new column with NULL values, then delete the old column and rename the new one to the same name, rather than update billions of rows i.e. create NewColumn with null values rename CurrentColumn to CurrentColumn_delete rename NewColumn to CurrentColumn Delete CurrentColumn_delete but only on the partition and not whole table
Asked by Crispin (81 rep)
Feb 2, 2022, 07:52 AM
Last activity: Jun 1, 2025, 08:05 PM