| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Column position
Hi,
Either way, Oracle will still consume atleast 1 byte for storing the null indicator value. Does not really matter where this column is positioned.
Regards
Rajagopal Venkataramany
On Tue, 20 Jun 2000 09:33:18 -0800, ORACLE-L_at_fatcity.com wrote:
> 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).
Regards
Rajagopal Venkataramany
 |
 |