Advertisement

Implementing Query Hints

  • Sam R. Alapati
  • Darl Kuhn
  • Bill Padfield

Abstract

Placing hints in SQL is a common and simple approach to improve performance. Hints influence Oracle’s optimizer to take a specific path to accomplish a given task, overriding the default path the optimizer may have chosen. Hints can also be viewed as a double-edged sword. If not implemented and maintained properly, they can hurt performance in the long run.

Keywords

Query Result Nest Loop Execution Plan Select Statement Access Path 
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.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Sam R. Alapati, Darl Kuhn, and Bill Padfield 2011

Authors and Affiliations

  • Sam R. Alapati
  • Darl Kuhn
  • Bill Padfield

There are no affiliations available

Personalised recommendations