Oracle OCW2022 RWP Performance Up Tips

• Better cardinality estimates
• Better execution plans
• More access paths available
• Ability for the optimizer to perform many transformations and optimizations (join elimination,materialized view rewrites, In-Memory Aggregation transformation, and many more)
• Partition pruning
• Exploit other technologies for optimal performance
    • Parallel Execution
    • Materialized Views
    • Compression
    • Database In-Memory

Autonomous Database can help address some problems:
• Augments bad/stale stats
• Dynamic statistics may correct some cardinality estimates (do not solely rely on dynamic statistics)
• Stats quality (every column has a histogram)
• Use of features like IMA, Columnar Cache in Flash is available

Where Autonomous Database cannot help:
• Suboptimal schema design
• Wrong data types on join keys
• Lack of constraints
• Sub-optimal partitioning strategy