Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2009
    Posts
    16

    Unanswered: use one big table or 2 !!!

    Hi,
    I need to design database for enterprise solution (office automation software).in this database i have a critical information that i'm not sure put all data in one table or derive data and put them into 2 tables(use primary and foreign key,...).
    I have a heavy search on this data (INSERT is fewer than SELECT) .
    now this is my question :
    for having best search performance,what should i do? (2 table or 1 big one)
    note that,if i have two tables, I should join them for search!!

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by farax_x
    for having best search performance,what should i do?
    index the table(s) properly

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    the indexes you need depend on the searches you will be doing.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •