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 Questionlkeeton20 Apr
  • undeleting tableGraeme B. Davis20 Apr
    • Re: undeleting tablesinisa20 Apr
    • Re: undeleting tableThimble Smith20 Apr
      • UPDATE Using values from another table...August Zajonc24 Apr
      • UPDATE using values from other table.August Zajonc24 Apr
        • Re: UPDATE using values from other table.sinisa24 Apr
  • Re: undeleting tablesasha20 Apr
    • RE: undeleting tableMark D Wolinski20 Apr
      • Re: undeleting tableThimble Smith20 Apr
        • Re: undeleting tableJeremy Cole20 Apr