The inventor of the relational model, Dr. Edgar Codd, was of the opinion that “[r]equesting data by its properties is far more natural than devising a particular algorithm or sequence of operations for its retrieval. Thus, a calculus-oriented language provides a good target language for a more user-oriented source language” (“Relational Completeness of Data Base […]
Read More
Learn about the importance of reviewing Oracle SQL plans in tuning SQL statements.
Read More
Learn how statistics are gathered for the Oracle CBO and improve your tuning efforts.
Read More
Learn how the Oracle cost-based optimizer (CBO) can impact performance.
Read More
Knowing how to use index hints can help you improve Oracle performance tuning.
Read More
Learn how Oracle optimizes partitioned queries and how this affects performance tuning.
Read More
Learn how Oracle uses the rule-based optimizer (RBO) and the cost-based optimizer (CBO) to decide on an execution plan.
Read More
Learn exactly how Oracle arrives at an execution plan for both the Oracle rule-based optimizer (RBO) and the cost-based optimizer (CBO).
Read More
Learn how to use the Oracle PLAN_TABLE and explain plans to guide performance tuning.
Read More
Key aspects of Oracle architecture may impact tuning efforts. Learn more.
Read More