Re: Question about using bind variables in static sql

Wrong.

If I run 1,000 queries per day against a data warehouse, and without Oracle 9,
and without the luxury of being able to
hint the code, then the fact that the parse time may be 5 hundredths of a second
longer on a 10 minutes query is irrelevant. The fact that I may use an extra 10 MB of shared pool is irrelevant.

The fact that I give the optimizer the best chance of picking the optimum access
path is MOST important.

And that's not the only special case.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases


damorgan wrote in message <3C9127B6.26BC17D3_at_exesolutions.com>...


>Let me make this as simple as possible ...

>

>Always always always use bind variables.

>

>If there is an exception it isn't worth worrying about.

>

>Daniel Morgan