From: Bruce Bristol <bbristol@ix.netcom.com>
Subject: Adding a new column
Date: 1997/02/02
Message-ID: <32F534EC.471E@ix.netcom.com>#1/1
content-type: text/plain; charset=us-ascii
organization: Netcom
x-netcom-date: Sun Feb 02  4:47:25 PM PST 1997
mime-version: 1.0
reply-to: bbristol@ix.netcom.com
newsgroups: comp.databases.oracle.server
x-mailer: Mozilla 3.0 (Win95; I; 16bit)



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