RE: Column position

The only issue can be with space utilization , better to keep varchar2 column with possible null values in the last.

-----Original Message-----
From: Witold Iwaniec [mailto:wiwaniec_at_novalistech.com] Sent: Tuesday, June 20, 2000 1:33 PM
To: Multiple recipients of list ORACLE-L Subject: Column position

Hi all

I have a table defined as:

my_table:

prt_name VARCHAR2(10) NOT NULL,
imp_date DATE NOT NULL,
atr_type CHAR(5) NOT NULL,
atr_data VARCHAR2(512)

There are millions of records in this table I would like to add another column:
exp_id VARCHAR2(10)

I can do it using the ALTER TABLE command and the column will end up as the last in the table or I can recreate the table, putting the column in different position, and reload the data. The column like atr_data is VARCHAR2 and can contain nulls. The table is just an example, I have number of tables to which I need to add another column.

Would there be a performance difference depending on the column position?

Thanks

Witold

-- 
Author: Witold Iwaniec
  INET: wiwaniec_at_novalistech.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).