Re: TKPROF output. Help, please!!!

Aren't you looking at explain plan like output. The number of rows is specified for each step in the plan, so you might have millions of rows selected, which are filtered away later on. If this doesn't answer your question please post the applicable part of the tkprof output.

Hth,

--
Sybrand Bakker, Oracle DBA
<suchandr_at_my-deja.com> wrote in message news:85im7n$gvr$1_at_nnrp1.deja.com...
> In the TKPROF output, for rows column in the
> execute row is showing millions of rows for a
> select statement, which is fetching only about
> 100 rows.
>
> The select stmt in question is being executed in
> a loop many times (each time it feches a single
> row), and CACHE hint is in place for this stmt.
>
> Does anyone know, what this enormous number of
> rows mean...(I was under the impresion, execute-
> >rows will be seen for insert/delete/update. Am I
> wrong?). Elapsed time for this is only 6.00
> seconds though!
>
> Any help would be much appreciated.
>
> Thanks,
> -Suresh.
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jan 12 2000 - 15:03:54 CST