First page Back Continue Last page Overview Graphics

Workshop

Bind Variable Peeking

Notes:

Bind Variable Peeking Workshop
Run the supplied script PEEK.SQL. This script demonstrates the effect of bind variable peeking.
Analyze the two execution plans displayed.
Why are they different?
If this represents the possible values used in the query’s bind variable, is it best to use bind variables or literals in this case?