| 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: Renaming columns ...
To add to Kirti's' comments -
The same applies for columns that have default values defined.
Lisa Koivu
Oracle Database Administrator
954-935-4117
The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful.
The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments.
-----Original Message-----
From: Deshpande, Kirti [SMTP:kirti.deshpande_at_verizon.com] Sent: Monday, June 04, 2001 11:56 AM To: Multiple recipients of list ORACLE-LSubject: RE: Renaming columns ...
Hi Raj,
The trailing null columns in a row do not take up any space in the data
block. So in a table with many columns, the columns that may contain null
values should be defined towards the end of the row to optimize disk space
usage.
HTH. Regards,
> -----Original Message-----
> From: Jamadagni, Rajendra [SMTP:Rajendra.Jamadagni_at_espn.com]
> Sent: Monday, June 04, 2001 9:32 AM
> To: 'Deshpande, Kirti'; ORACLE-L_at_fatcity.com
> Subject: RE: Renaming columns ...
>
> Kirti,
>
> Thanks for the info, BTW are there any significant advantages of moving
> NOT
> NULL columns towards HEAD of the table?
>
> Raj
> ______________________________________________________
> Rajendra Jamadagni MIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed here is personal and doesn't reflect that of ESPN
> Inc.
>
> QOTD: Any clod can have facts, but having an opinion is an art !
>
> *********************************************************************1
>
> This e-mail message is confidential, intended only for the named
> recipient(s) above and may contain information that is privileged,
> attorney work product or exempt from disclosure under applicable law. If
> you have received this message in error, or are not the named
> recipient(s), please immediately notify corporate MIS at (860) 766-2000
> and delete this e-mail message from your computer, Thank you.
>
> *********************************************************************1
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: kirti.deshpande_at_verizon.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).Received on Mon Jun 04 2001 - 12:47:32 CDT
 |
 |