0 - 2 of 2 tags for outer join
ON and WHERE clause for Joins

Hi, I have a doubt when coding ON and WHERE clause for Joins (Inner Vs Outer).

 

I think, for an Inner Join its does not make a difference whether we apply the condition with ON cluase or WHERE cluase.

 

Please refer the 2 queries belows-

 

sel customer_id,customer_name,order_amount

By gkatiyar, 21 Dec 2013 | Tagged: on where outer join | 4 comments
Outer Joins and Optimizer Issues

Hi all,
 

I'm having some performance issues due to the way certain queries are being processed by the optimizer. I have a set of views that I want to join together, and each of these views has the same JOIN/WHERE clause combination:
SELECT ...

By wpitterl, 25 Jun 2013 | Tagged: left outer join outer join optimizer optimizer plans view view definition join insider view join performance join filtering security table security view | 1 comment