New Oracle9i RDBMS features
Extending Oracle’s leadership
• Bitmap Join Indexes
• Analytic SQL fns
– Grouping sets
– FIRST/LAST aggregates
– Inverse distribution
– Hypothetical rank
• Proactive query governing
• Enhancements to MVs
– Broader refresh and
rewrite capabilities
– More sophisticated
summary advisor
• Full Outer Joins
• WITH-clause