Believe it or Not: Converting an Inner Join to an Outer Join to improve performance

(Iggy Fernandez) The cost-based optimizer tries to merge views whenever possible but sometimes we ma y want to override this behavior; that is, we may want the optimizer to push predicates into the view instead of merging the view into the main query.

Read More - Register for Free Membership