0 - 2 of 2 tags for join filtering
INNER VS OUTER JOINS effect of AND & WHERE

My Undesrstanding was this 

  • WHERE CLAUSE on an INNER JOIN CONDITION Vs  INNER JOIN  WITH AND <condition> will be the same 

e.g. A Inner Join B on A.x=B.y WHERE B.z between Date1 and Date2 
and 
e.g. A Inner Join B on A.x=B.y AND B.z between Date1 and Date2 

By DollarFromHash, 27 Oct 2015 | Tagged: sql left joins join filtering sql tuning
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