[SQL TUNING]The bind variables in a query

Giganews Newsgroups
Subject: [SQL TUNING]The bind variables in a query
Posted by:  jbmor…@gmail.com
Date: 14 Nov 2005

Hi,

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.

Replies