Physical Database Design

  • Tony Hasler
Chapter

Abstract

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.

Keywords

Prefix 

Copyright information

© Tony Hasler 2014

Authors and Affiliations

  • Tony Hasler
    • 1
  1. 1.BurntislandUnited Kingdom

Personalised recommendations