Comparing Two Oracle Schema | Redgate

An introduction to the basics of Oracle Cost-Based Optimizer. For more information on the Oracle Cost-Based Optimizer visit https://www.red-gate.com/simple-talk/databases/oracle-databases/oracle-cost-based-optimizer-basics-webinar/ When it comes to writing efficient queries there are a few key concepts that need to be understood. One of them is the Oracle Cost-Based Optimizer (CBO). Although it's called a cost-based optimizer it's actually not the cost we need to focus on primarily to understand why the optimizer makes certain decisions. In this webinar, you will learn the basics of the CBO, see why it is crucial that the optimizer’s picture of the data fits reality, why cardinality and selectivity estimates matter so much, and which key concepts the optimizer’s model surprisingly doesn’t cover (yet). Find out more at https://www.red-gate.com/simple-talk/databases/oracle-databases/oracle-cost-based-optimizer-basics-webinar/ #Oracle #OracleCostBasedOptimizer #CostBasedOptimizer