Re: optimizer and bind variables

thx Niall and Jonathan,

our decision is: using plain stmts coz nearly all our queries run very slow with prep stmts

"Steffen Ramlow" <s.ramlow_at_gmx.de> wrote in message news:a7slp6$nn6gi$1_at_ID-54600.news.dfncis.de...
> damned...
> so better not using bind vars???
>
>
> "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
> news:1017232072.4172.0.nnrp-14.9e984b29_at_news.demon.co.uk...
> >
> > Correct.
> >
> > --
> > 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
> >
> >
> > Steffen Ramlow wrote in message ...
> > >humm, so with ora 8.1.7 using bind var is bad when i have non-uniform
> > >distribution of a column value because histograms are never used with
> bind
> > >vars??
> > >
> >
> >
> >
>
>
Received on Thu Mar 28 2002 - 01:57:18 CST