Advertisement

Directives and Statistics Feedback

  • Stelios Charalambides
Chapter

Abstract

In 11g there was a feature called Cardinality Feedback. This reoptimized (hard parsed) a query if the Cardinality Estimate of the final result was more than a certain factor out from the actual result. This was a nice simple feature that was easy to understand. If you saw this note at the end of an execution plan, you knew that Cardinality Feedback had been used.

Keywords

Statistics Feedback Performance Feedback Parallel Execution Execution Plan Select Statement 
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

© Stelios Charalambides  2017

Authors and Affiliations

  • Stelios Charalambides
    • 1
  1. 1.New HamptonUSA

Personalised recommendations