|
Sonu619
Posting Yak Master
193 Posts |
 Posted - 12/10/2012 : 23:21:03
|
Guys need Advise.
Here is Sample Datad
Option 1
SELECT
T.ID,
G.FNAME,
G.LNAME,
H.QUICK
From Table1 T,Table2 G,Table3 H
Where T.ID = G.ID
AND G.PID = H.PID
Option 2
SELECT
T.ID,
G.FNAME,
G.LNAME,
H.QUICK
From Table1 T
INNER JOIN TABLE2 G ON T.ID = G.ID
INNER JOIN TABLE3 H ON G.PID = H.PID
My question is what do you think which Option will give better Performance
Option 1 Or Option 2
Thank You in advance. |
|
Better Performance
