Re: Limit of 1050 columns for ANSI joins


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

.

Relevant Pages

  • Seeking advice: How to recruit survey volunteers
    ... Recently I posted an announcement here on motss about an online survey of sexual attraction. ... Does anyone have any advice on other strategies I can use for online recruitment to the study? ... I've taken special care to ensure confidentiality (survey conducted using https, IP addresses not recorded, etc.). ... will NOT be linkable to your responses, your e-mail, or your identity.) ...
    (soc.motss)
  • Spammers/Scammers/Virus Writers Do Not Take Holidays
    ... Consumers who shop and bank online believe criminals have no plans to ... A survey released this week by computer maker Sun Microsystems ... Yet these same consumers expect companies to protect them. ...
    (comp.dcom.telecom)
  • RE: For Duane Hookom
    ... question then the new question prior to adding possible responses. ... "dee" wrote: ... When I add an additional question in the sub-form to any survey there is no ... "Duane Hookom" wrote: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Questionnaire
    ... "Basil" wrote in message ... > And what a great system At Your Survey is too... ... > - User interface populates both the normal respondents table as ... into the main responses table - with 1 record per answer. ...
    (microsoft.public.access.tablesdbdesign)
  • REPOST + Begging: Multiple Apps on UNIX?
    ... We originally posted this survey two days ago and have not received ... anywhere near the number of responses we desire. ... single UNIX systems? ... Of the UNIX servers you have knowledge of, ...
    (comp.sys.sun.admin)