Final State Optimization

  • Tony Hasler


When I introduced the CBO in Chapter 2 I explained that the CBO followed two processes to come up with an execution plan for the runtime engine: query transformation and final state optimization. In this chapter I will cover final state optimization, and transformations will be the focus of Chapter 13. Put another way, this chapter looks at how the CBO evaluates different candidate execution plans after any query transformations have been performed.


Nest Loop Access Method Execution Plan Full Table Candidate Query 
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.

Copyright information

© Tony Hasler 2014

Authors and Affiliations

  • Tony Hasler
    • 1
  1. 1.BurntislandUnited Kingdom

Personalised recommendations