Physical Database Design

  • Tony Hasler


For the runtime engine to execute a SQL statement with adequate performance, you must provide it with a properly sized machine that has an adequate SGA and an adequate PGA. However, physical database design is also crucial: even with a reasonably sized machine, a well-written SQL statement, and a CBO that makes all its cardinality estimates perfectly, you are unlikely to get decent performance unless you pay attention to the physical database design.


Nest Loop Execution Plan Index Compression Index Block Full Table 
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