Join factorization, a new Oracle DB 11gR2 feature ↗
Hong Su from Inside the Oracle Optimizer:
The Join Factorization transformation was introduced in Oracle 11g Release 2 and applies to UNION ALL queries. Join factorization is a cost-based transformation. It can factorize common computations from branches in a UNION ALL query which can lead to huge performance improvement.
Yet another reason to upgrade to 11gR2.
Related articles:
- Did You Know This About Outer Joins in Oracle?
- When ANSI SQL Join Syntax Does Not Work in Oracle
- One more reason to upgrade your Oracle 8i
Filed in Links, Oracle on 25 Feb 11 | Tags: performance, sql
About This Blog
- Subscribe by Email
-
-
-
- The views expressed on this blog are mine alone and do not necessarily reflect the views of my employer.
