Table Order in Join [message #674657] |
Thu, 07 February 2019 09:27 |
|
rrcr
Messages: 18 Registered: January 2019
|
Junior Member |
|
|
Hi ,
I have two doubts.
1. Order of tables in Join
select * from A,B,C
where A.C1=B.C1
AND B.C1=C.C1;
Vs
select * from C,B,A
where C.C1=B.C1
AND B.C1=A.C1;
with table order is there any performance differences if so which one is better?
2. Join Syntax
select * from A,B
WHERE A.C1=B.C1;
VS
SELECT * FROM A
INNER JOIN B
ON A.C1=B.C1;
these two have performace differences if so which one is better?
Thanks
|
|
|