Database Tables

I know many of the benefits of using multiple tables at the same time. Some of the disadvantages could be tables not connected when you are trying to update the underlying database and The syntax can be cryptic when using .NET unless you are experience in it. I cannot think of anymore disadvatages, In your professional opinion, what other dissadvanges can there be when using multiple tables?
rafaelmunoz2Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kim RyanIT ConsultantCommented:
I assume you are mainly usig multiple tables to preforms joins to retrive reltated data.

The main drawback is speed, it will always take more time to perform the join then retrieve  data from a single table. Where speed is a greater concern than data redundancy/integrity,  the join can be replaced by storing the joined value directly inside the main table. This is referred to as de-nomalization and it used quite often.
0
rajendraoneCommented:
As you have to deal with multiple tables you must be using lots of join statements. Join statements create lots of temporal queries and thus high memrory requirement. So performance issues are always there when executing join statements in huge databases.
The join performance depends on the number of records you result joining than the number of tables. As many tables you join its only making up statement difficult. However, for better performance you have to be very careful on the kind of join statement you construct.  Like avoiding joining tables with few unique values, ensuring that joining columns have their own index values, using ANSI syntaxes etc.

Read this artical on how you can tune your queries on JOIN statements. Follow these guidelines. You will end up with quite an efficient queries that will boost your performance.

http://www.sql-server-performance.com/tuning_joins.asp

Thank you,
Rajendra Adhikari
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rafaelmunoz2Author Commented:
teraplane, rajendraone;
     Thanks for all the information. It has been help and it actually help see a lot of "disadvantages" on using multi tables.
   Thanks for your help!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.