RelationalDBDesign
SiteMap
Advanced Tuning
SQL Tuning
Perform Tuning
Tuning Instance
Tuning Basics
External Environment
Rule Based Optimizer
«Prev
Next»
Oracle SQL Tuning
Tuning Oracle SQL
Extension ANSI SQL
SQL Tuning Tool Set
Executing Oracle SQL
Explain Plan Utility
SQL Optimizer Modes
Rule Based Optimizer
SQL Tuning Hints
ANSI SQL Extensions
Built in Functions
Oracle null Value BIF
Decode Function
Grouping Rollup bifs
Supplied Extensions
Extensions Conclusion
SQL Tuning Tools
DBA SQL Roles
Developers Write SQL
Inside Stored Procedures
SQL Tuning Tools
Explain Plan Utility
SQL Declarative Language
Oracle Plan Table
Explain Plan Statement
Full Table Scan
Diagnose Table Joins
Non Correlated Subqueries
Index Range Scans
Analyze Explain Plan
SQL Explain Plan Conclusion
SQL Optimizer Modes
Optimizer Modes
Default Optimizer Mode
SQL Optimizer Modes
Rule Based Optimizer
Lesson 8
Effective tuning tips for rule-based optimization
Objective
Evaluate and tune rule-based queries.
When we evaluate and tune rule-based SQL queries, we should always follow this procedure.
Now let us wrap-up this module with a review.