Re: Limit of 1050 columns for ANSI joins

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 08 Jun 2006 21:16:49 +0200
Message-ID: <tptg82lf8br5rh8n7kra9g7js890rvvl4c@4ax.com>

On Wed, 7 Jun 2006 14:06:42 -0700, "Andreas Sheriff" <spamcontrol_at_iion.com> wrote:

>One solution that I proposed was to create (a) separate table(s) for each
>survey's responses, with each column being a response.

I have seen a different approach in operation each record was one question, each column was a respondent. As the number of choices was usually below 16, it was possible to store 2 respondents in a column, by using bit-masking. Worked quite nicely!

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Jun 08 2006 - 14:16:49 CDT