SQL Performance (MOSC)

MOSC Banner

Which is better from a performance point of view

edited Apr 22, 2021 3:19PM in SQL Performance (MOSC) 6 commentsAnswered ✓

Hi All

Kindly, Which is better from a performance point of view, if I am creating a simple generic view joining 3 tables (customer, orders, order's lines), which of the 3 tables to be my main base table in the select statement

(A)

select * from orders

join order_lines 

join customer

(B)

select * from customer

join orders

join order_lines


(C)

select * from order_lines

join orders

join customer


Thanks ...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center