0 - 3 of 3 tags for sql tuning
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
A Structured Method for Tuning Teradata SQL

SQL performance is vital for driving value from a data warehouse. With today's growing query complexity, optimizing SQL can be a daunting task ...

By DebraH, 17 Nov 2014 | Tagged: performance tuning method methodology sql tuning
Join through view and performance issue

We have multiple views that are being joined and within the views are complex logics and one of the logic is to have timestamp (4) as part of the join column.  When parsing the query and running the explain it is taking longer,  over a min.  Looking at the explan, the timestamp is taking part on the join.

By jobbazar, 14 Apr 2014 | Tagged: Peroformance sql tuning PE bug | 1 comment