Re: Forms, bind variables and index use

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.