I have some very large tables in which I'd like to drop some columns. Based
on the overhead of a drop column revisiting every block to coalese the free
space, I'd like to mark them unusable for the time being and just reorg them
in a few weeks. I'm pretty sure that new inserts to the table will fill
blocks correctly. But ,what exactly happens when I update a row that
contains a column that has been marked unusable. Does the row get adjusted
during the update or does the entire block get adjusted? What about a large
batch update to these rows?
TIA
Craig
Received on Thu Nov 15 2001 - 22:11:29 CST
