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: Limit of 1050 columns for ANSI joins

Re: Limit of 1050 columns for ANSI joins

From: joel garry <joel-garry_at_home.com>
Date: 7 Jun 2006 14:53:33 -0700
Message-ID: <1149717213.193786.227110@f6g2000cwb.googlegroups.com>

Andreas Sheriff wrote:

>
> The app is an online survey management system and it stores all responses in
> one table:
>
> questionresponses:
> ...
> takerid
> questionid
> choiceid
> choicetext
> ...
>
> Many self joins have to be made to do online reporting and exporting data
> from this table; hence the magnificent ANSI join.
> Materialized views may help, but I'm using Standard Edition.
>
> One solution that I proposed was to create (a) separate table(s) for each
> survey's responses, with each column being a response. Sure, it's DDL
> everytime someone creates a survey, but that doesn't happen as often as
> someone taking a survey or doing online analysis. Separate tables would
> eliminate the need for magnificent ANSI self joins and speed up the
> application.
>
> --
>
> Andreas Sheriff
> Oracle 9i Certified Professional
> Oracle 10g Certified Professional
> Oracle 9i Certified PL/SQL Developer
> ----
> "If you don't eat your meat, you cannot have any pudding.
> "How can you have any pudding, if you don't eat your meat?"

Andreas, if you don't start normalizing, we'll send you to your room with no supper at all!

jg

--
@home.com is bogus.
Witness the man who raves at the wall
Making the shape of his question to heaven
Whether the sun will fall in the evening
Will he remember the lesson of giving
Set the controls for the heart of the sun
The heart of the sun 
The heart of the sun
Received on Wed Jun 07 2006 - 16:53:33 CDT

Original text of this message

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