Beyond Data Access and Join Optimization

  • Christian Antognini


The optimization of data accesses and joins must be performed before considering the advanced optimization techniques presented in this chapter. In fact, the optimization techniques described here are intended only to further improve performance when it isn’t possible to achieve it otherwise. In other words, you should fix the basics first, and then, if the performance is still not acceptable, you can consider special means.


Execution Plan Query Optimizer Database Instance Database Engine Slave Process 

Copyright information

© Christian Antognini 2014

Authors and Affiliations

  • Christian Antognini
    • 1
  1. 1.Monte CarassoSwitzerland

Personalised recommendations