Re: add a new column into the middle of an existing table

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 01 May 2002 20:55:50 GMT
Message-ID: <3CD05653.C7F876E2_at_exesolutions.com>


Chris Weiss wrote:

> Please see Pablo Sanchez's response. Location does matter, and it is based
> on benchmarks.
>
> --
>
> ~~~~~~~~~~~~~~~~
> Chris Weiss
> chris_at_hpdbe.com
> www.hpdbe.com
> High Performance Database Engineering
> ~~~~~~~~~~~~~~~~
>
> "J.P." <jp_boileau_at_yahoo.com> wrote in message
> news:7e388bc3.0205010457.701efd87_at_posting.google.com...
> > You gott'a stop thinking in non Relational-DB style...
> >
> > The physical location of a column is totally irrelevant in a RDBMS.
> >
> > JP
> >
> > leiwang_q_at_hotmail.com (lei wang) wrote in message
> news:<af074b9c.0204301247.65da02f9_at_posting.google.com>...
> > > Is there an easy way to add a new column into the middle of an
> > > existing table? Seems to me that you have to create a new table and
> > > copies data from the old table. <Alter table add column> statement
> > > will only adds columns at the end of an existing table.
> > >
> > > I am using Oracle 8.1.7 EE on Solaris 2.7.
> > >
> > > Thanks.

Thanks. And good information.

But of every 1,000 people wanting to re-order a table. One does it for performance and 999 do it because it makes them feel good.

Daniel Morgan Received on Wed May 01 2002 - 22:55:50 CEST

Original text of this message