Re: Mysql Performance on large joins
Posted by:
beau
Date: March 16, 2005 11:18AM
Answer: If you have two or more tables that are frequently joined together, then the columns used for the joins on all tables should have an appropriate index.
This is especially important when the fields used for the joins are anything other than integer values.
a good link to sql performance tuning:
http://www.sql-server-performance.com/tuning_joins.asp
Subject
Written By
Posted
Re: Mysql Performance on large joins
March 16, 2005 11:18AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.