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!!