Re: Forms, bind variables and index use

Thanks.

That's the problem with listservs, things sometimes slip through.

Regards,

Pat.

"Thomas J. Kyte" wrote:

> In article <39176BE7.4792B088_at_ns.sympatico.ca>,
> lori.pat_at_ns.sympatico.ca wrote:
> > Someone posted a message on this listserv last weekend, saying that
> > Oracle Forms do not use indexes when bind variables are involved, and
> > that 8.1.6. tries to address this.
> >
> > Is this true?!
> >
> > This implies that applications built using Oracle forms can become a
> > performance problem server-side, if they don't use indexes!
> >
> > Thanks.
> >
> > Pat.
> >
> >
>
> they were horribly confused. I didn't see their post, but if your gist
> is correct -- they are wrong.
>
> forms would not decide if an index is used anyway -- thats a function
> of the database. forms develops queries that can and will make use of
> available indexes.
>
> --
> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries
> http://osi.oracle.com/~tkyte/index.html
> --
> Opinions are mine and do not necessarily reflect those of Oracle Corp
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue May 09 2000 - 00:00:00 CDT