0 - 2 of 2 tags for optimizer plans
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
Explaining the EXPLAIN

A topic that is essential for all SQL programmers and database designers. This session examines the mysteries of the English text that appears when an EXPLAIN is requested.

By DebraH, 09 Jan 2012 | Tagged: explain visual explain optimizer plans explain terminology explain text