21 September, 2007

More on Bind Variable Peeking and Execution Plans

Here's how Tom Kyte used the example of a the mystery why a query with SQL_TRACE enabled seemed to perform better than the same query by itself --- because it was being parsed as two different queries when Bind Variable Peeking saw different values.
To the many responses about bind variable peeking, he further reviews some of the options.

1 comment:

Babu said...

Nice Post..

Babu B
http://babudba.blogspot.com