| List: | General Discussion | « Previous MessageNext Message » | |
| From: | lkeeton | Date: | April 20 2000 1:46pm |
| Subject: | Table Design Question | ||
| View as plain text | |||
I have a question about tables. If I have 17 fields in my table, and had about 4 fields where actually the table search and scans actually go to(Where key > 4 is an example what I mean). Is it more efficient just to keep these fields in the table in that their in now, or should I make this relational and put that field a foreign key in another table. So in the other table I have the item# and this key(12345678) which is auto-incremented. I don't know if this will make a difference, if it will I would be glad to know about it.\ Thanks Brent Keeton
| Thread | ||
|---|---|---|
| • Table Design Question | lkeeton | 20 Apr |
| • undeleting table | Graeme B. Davis | 20 Apr |
| • Re: undeleting table | sinisa | 20 Apr |
| • Re: undeleting table | Thimble Smith | 20 Apr |
| • UPDATE Using values from another table... | August Zajonc | 24 Apr |
| • UPDATE using values from other table. | August Zajonc | 24 Apr |
| • Re: UPDATE using values from other table. | sinisa | 24 Apr |
| • Re: undeleting table | sasha | 20 Apr |
| • RE: undeleting table | Mark D Wolinski | 20 Apr |
| • Re: undeleting table | Thimble Smith | 20 Apr |
| • Re: undeleting table | Jeremy Cole | 20 Apr |
