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.
| 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. |
 |
|
|
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 MRegards,Arun JM |
|
|
|
|
|
|
One big table or two small one