Have you considered using the SET datatype? It would be perfect for your
situation.
- Original Message -
From: "Nino Skilj" <[EMAIL PROTECTED]>
To: "'Tbone'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, February 23, 2001 7:38
-
> From: Tbone [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 23, 2001 4:18 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Table Design -- which is better?
>
>
> Hi,
> How would the data look a like.
> And how about the query's
>
> Greetz Tbone
> ---
The data would be 1's and 0's (on/off)
Nino
-Original Message-
From: Tbone [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 23, 2001 4:18 PM
To: [EMAIL PROTECTED]
Subject: Re: Table Design -- which is better?
Hi,
How would the data look a like.
And how about the query'
Hi,
How would the data look a like.
And how about the query's
Greetz Tbone
- Original Message -
From: "Nino Skilj" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 24, 2001 12:17 AM
Subject: Table Design -- which is better?
> I have a g
I have a general design question.
Is it better to design one table with 45 columns or to split it into 3
tables with 15 columns each. There would be about 5000 rows in the table and
it would be used more for reading rather than writing.
I'm new to this, is there anything I'm missing?
Thanks,
N