Re: Help with my sql load performance

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 14 Apr 2007 13:29:07 -0700
Message-ID: <1176582540.138302@bubbleator.drizzle.com>

Jeremy wrote:
> In article <1176479781.740881_at_bubbleator.drizzle.com>, DA Morgan says...

>> Again ... a table with 200 columns is a strong indication of a bad
>> design.
>>

>
> If all the attributes logically belong to the same PK, why is it
> indicative of a bad design?

The following also relate to the same PK.

CREATE TABLE bad_design (
QID NUMBER(5),

Q1   VARCHAR2(1),
Q2   VARCHAR2(1),
Q3   VARCHAR2(1),
Q4   VARCHAR2(1),
Q5   VARCHAR2(1),
Q6   VARCHAR2(1),
Q7   VARCHAR2(1),

...
Q199 VARCHAR2(1)); If you don't see anything wrong with your argument let me know.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sat Apr 14 2007 - 15:29:07 CDT