What do you infer from this?
A. The second plan was created because the first plan was aged out.
B. The CURSOR_SHARING parameter value was changed to EXACT after the second query was executed.
C. The third plan was created because the first plan was aged out and the second plan had different selectivity.
D. The first two executions used the same plan because at parse time the optimizer did not consider selectivity as the cursor was not yet considered bind-aware.
Answer:D
What do you infer from this?
A. The second plan was created because the first plan was aged out. B. The CURSOR_SHARING parameter value was changed to EXACT after the second query was executed. C. The third plan was created because the first plan was aged out and the second plan had different selectivity. D. The first two executions used the same plan because at parse time the optimizer did not consider selectivity as the cursor was not yet considered bind-aware.