Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle - Column Order

Re: Oracle - Column Order

From: Billy <vslabs_at_onwe.co.za>
Date: 18 Oct 2005 03:28:02 -0700
Message-ID: <1129631282.020460.13260@z14g2000cwz.googlegroups.com>


DA Morgan wrote:
>
> Why? What possible difference could it make?

Move columns that are usually nulls to the end of the table. Having null column trailing, reduces row space footprint (a teensy tad - but can make a difference with VLTs).

But then this not something that the OP has likely in mind? Conceptually - agree whole heartedly: the order of columns in a table has *NO* significance to application development, developers and end-users.

--
Billy
Received on Tue Oct 18 2005 - 05:28:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US