Advertisement

Configuring the Optimizer

  • Sam R. Alapati
  • Darl Kuhn
  • Bill Padfield
Chapter

Abstract

The cost optimizer determines the most efficient execution plan for a SQL statement. The optimizer depends heavily on the statistics that you (or the database) gather. This chapter explains how to set the optimizer goal and how to control the behavior of the optimizer. You’ll learn how to enable and disable automatic statistics collection by the database and when to collect statistics manually. You’ll learn how to set preferences for statistics collection as well as how to validate new statistics before making them available to the optimizer. The chapter explains how to lock statistics, export statistics, gather system statistics, restore older versions of statistics, and handle missing statistics.

Keywords

Statistic Collection Execution Plan Bind Variable Full Table Dynamic Sampling 
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

© Sam R. Alapati 2013

Authors and Affiliations

  • Sam R. Alapati
    • 1
  • Darl Kuhn
    • 1
  • Bill Padfield
    • 1
  1. 1.TXUS

Personalised recommendations