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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2017 Stelios Charalambides
About this chapter
Cite this chapter
Charalambides, S. (2017). Directives and Statistics Feedback. In: Oracle SQL Tuning with Oracle SQLTXPLAIN. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-2436-6_12
Download citation
DOI: https://doi.org/10.1007/978-1-4842-2436-6_12
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-2435-9
Online ISBN: 978-1-4842-2436-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books