Which way is right for getting performance?
Hi friends,
I have table as t1, t2, t3 on MyISAM engin.
Relation is established between
t1 and t2
t2 and t3
with one to one mapping.
I want to get result from all 3 tables, which I can get by joinning also or I can join only t1 and t2 after that I can select data only from t3 by sendding directly it's primary key.
Whether I go for joinning 2-3-4 tables or go for selecting each row seperatly from single table as their is 0ne to one mapping.
Which will be better?
Thanking you?
Plz consider MyISAM engine.
Subject
Views
Written By
Posted
Which way is right for getting performance?
2267
October 22, 2009 06:20AM
1315
October 23, 2009 10:19AM
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.