Cardinality Feedback (CFB) is a feature of the Oracle Optimizer for correcting cardinality estimation (i.e., number of rows returned by each operation) in execution plans. Rather than going to endless complications to determine the right cardinality, we just wait for the result of each step in the execution plan, store it in the shared pool and reference it on subsequent executions, in the hope that the information will give us a good idea of how well we did the last time.
CFB is a feature of Oracle 11gR2. For more details read the following post.
In this post, we will show CFB in action.
CFB is a feature of Oracle 11gR2. For more details read the following post.
In this post, we will show CFB in action.
