Which is better from a performance point of view
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 ...