11g New Feature: Extended Optimizer Statistics

Posted at Tuesday, October 30, 2007

In 11g you can now correlate the relationship between 2 skewed columns. Here is a great 'Oracle by Example' article that exhibits how you can use extended statistics to aid the optimizer's explain plans: Using Extended Statistics to Optimize Multi-Column Relationships and Function-Based Statistics

Labels: 11g, Statistics, Tuning