Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 One big table or two small one

Author  Topic 

farax_x
Starting Member

3 Posts

Posted - 2009-09-07 : 06:24:05
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!!

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-09-07 : 07:18:55
On table with proper (clustered) index should be ok.
But that depends on data structure. If data would be redundant I would take more than one table.
Without knowing the data structure there is nothing more to say.



No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

ojsanthosh
Starting Member

2 Posts

Posted - 2009-09-08 : 07:44:54
Hi,

Better u have it on two tables, because it helps u to maintain the data in good way.

Thanks,
Arun J M

Regards,

Arun JM
Go to Top of Page
   

- Advertisement -