Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with my sql load performance
In article <1176582540.138302_at_bubbleator.drizzle.com>, DA Morgan says...
> 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.
>
Hi Daniel, first let's be clear: I haven't presented an argument, merely a question. I don't understand your intended purpose of the table you have suggested above. What I am asking is why a high number of columns in a table is indicative of bad design. Genuine question.
-- jeremyReceived on Tue Apr 17 2007 - 05:18:57 CDT