Adding a new column

From: Bruce Bristol <bbristol_at_ix.netcom.com>
Date: 1997/02/02
Message-ID: <32F534EC.471E@ix.netcom.com>#1/1

Hello,

We have 8 Oracle tables which contain anywhere from 14 to 50 million rows (most are around 25M).

We need to add a new column, and I know I can do this.

I'm going to have each table unloaded and truncated for a purge process we do quarterly.

What will be better for performance? Adding the new column and then reloading the data (which doesn't have the new column at the end), or reload the data and then add the column?

Thank you!

-Bruce Received on Sun Feb 02 1997 - 00:00:00 CST