Re: Bind Variables...

In article <9s9lm4$edf$1_at_innbox.cnet.com>, "Jack says...
>
>I have been debating the answer for this question.... but not really into a
>solution,,,,
>
>When to and When not to use bind variables???
>

99.999999% of the time -- use bind variables.

In a datawarehouse, where you have computed histograms and have very skewed data -- skip the bind variable on that column -- sometimes.

>When to and When not to placeholder columns(&) ?/
>

only when forced to.

>Thanks
>Jack....
>
>
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp