By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,127 Members | 1,343 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,127 IT Pros & Developers. It's quick & easy.

Adding a column - Column oder a concern?

P: n/a
I have a table that currently contains 718000 rows. I wish to add a
column to the table. Adding this column anywhere other than the end of
the table requires exporting data, a drop and recreate, then a
re-import of data. Is there any disadvantage to adding this column to
the end of the table. Will this fragment the table. Is a reorg needed?

Thanks,

- CBC
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Chris,

In reality there is no difference.
In theory (or when running a benchmark where 0.1% are a measure of
success) there are. Tuning the column ordering is not worth your money.

Cheers
Serge
Nov 12 '05 #2

P: n/a
cb****@gmail.com (Chris Cobb) wrote in message news:<fc************************@posting.google.co m>...
I have a table that currently contains 718000 rows. I wish to add a
column to the table. Adding this column anywhere other than the end of
the table requires exporting data, a drop and recreate, then a
re-import of data. Is there any disadvantage to adding this column to
the end of the table. Will this fragment the table. Is a reorg needed?

Thanks,

- CBC

Generally there is no problem adding a column to the end of a table.
The space is not actually allocated until you insert/udpdate the row,
or do a reorg. It is generally better to do a reorg before doing large
updates to the table with a new column, since the old row will usually
not fit back in the same space as the row before the new data is
added.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.