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: Do columns with Null data take up space?

Re: Do columns with Null data take up space?

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sun, 05 Dec 2004 11:02:58 -0800
Message-ID: <1102273276.950786@yasure>


nullpointer wrote:

> But I thought the OP mentioned the need for one row per test set. I
> doubt he has any control over the 3rd party app. One could pivot the
> table you are proposing and build a view but the performance might
> take a hit.
>
> Regds
> Dev

He may need one row per test set as an output. But that is no way to store the data.

No version is mentioned ... but with 10g there is no need to be constrainted by bad application developer design. One can always use advanced rewrite.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Sun Dec 05 2004 - 13:02:58 CST

Original text of this message

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