Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query uses index in SQLPlus but not in PLSQL
Have you analyzed your query execution using TKPROF ?
Neil Cudd <neil_at_cudd.demon.co.uk> a écrit dans l'article
<948291247.2321.0.nnrp-10.c2de6f3d_at_news.demon.co.uk>...
> Irritating problem here.
>
> I have a query which, when I run in SQLPlus or worksheet or svrmgr or
> anywhere else, uses an index that matches the where clause. As soon as I
put
> this query into a PLSql proc it doesn't use the index.
>
> The only difference is when the query is executed from sqlplus etc, I
> hardcode the search predicates, but when in PLSql they are variables
(same
> value though).
> Have tried hints, no good.
>
> Any ideas out there ?
>
> Thanks,
> NeilC.
>
>
>
Received on Wed Jan 19 2000 - 09:33:05 CST