Articles tagged

03 February 2017
03 February 2017

Understanding SQL Query Parsing: Part 4 – Understanding Bind Variable Peeking

In the 3rd part of this series, I introduced you to the concept of the bind variables. We also learned their importance in regard to cursors, i.e. how with the presence of bind variables, cursor reparsing can be reduced significantly. But as is famously said in the world of performance tuning, there is nothing black or white: it’s all grey… Read more