Understanding the Oracle Cost-based Optimizer (CBO)
Learn how the Oracle cost-based optimizer (CBO) can impact performance.
Read MoreMost Popular Databases
Using Index Hints to Tune Oracle Performance
Knowing how to use index hints can help you improve Oracle performance tuning.
Read MoreUsing Driving Table Hints to Tune Oracle Performance
Learn how to diriving tables hints to improve Oracle performance tuning.
Read MorePartitioned Query Explain Plans
Learn how Oracle optimizes partitioned queries and how this affects performance tuning.
Read MoreOracle Explain Plans: Driving Tables and Table Joins
Learn how a query’s driving table can impact Oracle performance.
Read MoreWhy Virtualization Matters to Your Career as an Oracle RAC DBA
Learn what every DBA should know about how to deploy, manage and optimize performance of Oracle RAC in a virtualized environment.
Read MoreReading Oracle Explain Plans, Part 2: the RBO and the CBO
Learn how Oracle uses the rule-based optimizer (RBO) and the cost-based optimizer (CBO) to decide on an execution plan.
Read MoreReading Oracle Explain Plans, Part 1: The Basics
Learn exactly how Oracle arrives at an execution plan for both the Oracle rule-based optimizer (RBO) and the cost-based optimizer (CBO).
Read MoreUnderstanding Oracle Explain Plans
Learn how to use the Oracle PLAN_TABLE and explain plans to guide performance tuning.
Read MoreHow Oracle Architecture Affects Performance Tuning
Key aspects of Oracle architecture may impact tuning efforts. Learn more.
Read MoreHave you made these 5 database design mistakes?
Want to save your company money, headaches for end-users, and ensure data quality? Avoid these five database design mistakes.
Read MoreSQL Server Buffer Cache Hit Ratio
The buffer cache hit ratio details the percentage of pages found in the SQL Server buffer pool. Learn why it doesn’t tell enough about SQL Server performance.
Read More