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.
Received on Wed May 01 2002 - 14:39:15 CDT
