|Subject:||[SQL TUNING]The bind variables in a query|
|Date:||14 Nov 2005|
What do I do when I find:
SELECT XXX, YYY, FROM ZZZ ....
WHERE XXX = BindVariable:
in the shared pool,
and I want to perform an explain plan on that query?
Obviously depending on the number of rows selected, my SQL tuning
strategy varies a lot.
I need to know the value in the variable at runtime.
If anyone has an idea, please let me know.