Home » RDBMS Server » Performance Tuning » Table Order in Join (11g)
Table Order in Join [message #674657] Thu, 07 February 2019 09:27 Go to previous message
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
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: RELY constraints
Next Topic: high buffers
Goto Forum:
  


Current Time: Tue Jan 21 05:20:38 CST 2020