Optimizer Transformations: Table Expansion

(Allison) The table expansion transformation was introduced in 11gR2, to improve performance of a specific category of queries. If you understand how the transformation works, you can tailor your indexing scheme to improve plans. We added the transformation based on a few key observations:

Read More - Register for Free Membership