The Cost-Based Optimizer
Tony Hasler · Apress eBooks · 2014
Chapter 1 introduced the CBO. It is the job of the CBO to determine how to set about running your SQL statement. An approach to executing an SQL statement is known as an execution plan , and for very simple statements, there may only be one way to set about doing the task. Therefore, there will only be one possible execution plan. However, for the vast majority of SQL statements, there are different possible execution plans from which the CBO must choose. In English language, optimization means picking the best from a number of options, and in this case the CBO is trying to pick the optimal execution plan from all of the possible plans it identifies. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.