Re: Not Nulls grouped as first column.....

The idea wasn't so much to keep "not nulls" at the front, as to keep "usually null"'s at the end - reason being that Oracle won't store unnecessary contiguous null columns at the end of a row.

Tao36 wrote:
>
> I've always been told to keep all my "not null" columns together at the front
> of the table. However, due to the severe effects of aging (or possibly
> environmental contaminants) I can't remember why.
>
> I have a situation in which it is a lot easier for me to "alter" a table,
> adding a new "not null" column to the end, as opposed to "dropping" the table
> and recreating it with the new column grouped at the front with all his "not
> null" buddies.
>
> What are the effects of not grouping my "not nulls"? Catastrophic? Mild
> annoyance? Was it anal to keep them together in the first place?
>
> Thanks for any enlightenment.
> Kevin
 

-- 
Steve Moreland
DBA, LanVision Inc.

Remove "no.spam" from my email
 address to reply