Re: Table Design -- which is better?

2001-02-23 Thread Jason Landry
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

RE: Table Design -- which is better?

2001-02-23 Thread Atle Veka
- > 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 > ---

RE: Table Design -- which is better?

2001-02-23 Thread Nino Skilj
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'

Re: Table Design -- which is better?

2001-02-23 Thread Tbone
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

Table Design -- which is better?

2001-02-23 Thread Nino Skilj
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