tkprof: who can help to understand

From: <zyman_at_my-deja.com>
Date: Fri, 22 Sep 2000 20:18:38 GMT
Message-ID: <8qgeq9$o94$1@nnrp1.deja.com>

Hi
 I got this from tkprof.

select sb.*
from
pirweb.sched_bulletins sb
where
(sb.bulletin_no in (select distinct(bb.bulletin_no)

                   from pirweb.bts_bulletin_v bb))

or
(sb.bulletin_no in (select distinct(bp.bulletin_no)

                  from pirweb.bts_promo_v bp ))

call  count  cpu  elapsed  disk  query	current  rows ------- ------ 
-------- ---------- ---------- ---------- ----------  ---------- Parse	1 
0.00  0.00  0  0  0  0 Execute	1  0.00  0.00  0  0  0	0 Fetch  3  0.00 

0.00 142630 143706 13740 1031 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 142630 143706 13740 1031

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 30 (PIRWEB)

Rows Execution Plan -------

---------------------------------------------------  0	SELECT STATEMENT 
GOAL: CHOOSE  0  FILTER  0  TABLE ACCESS (FULL) OF 'SCHED_BULLETINS'  0 
TABLE ACCESS (FULL) OF 'ALL_BULLETINS'	0  TABLE ACCESS (FULL) OF

'ALL_BULLETINS'

---

***

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call  count  cpu  elapsed  disk  query	current  rows ------- ------ 
-------- ---------- ---------- ---------- ----------  ---------- Parse	1 
0.00  0.00  0  0  0  0 Execute	2  0.00  0.00  0  0  0	0 Fetch  3  0.00 

0.00 142630 143706 13740 1031 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 142630 143706 13740 1031

Misses in library cache during parse: 1
Misses in library cache during execute: 1

The question is : why I have such interesting numbers in COUNT column 1-2-3 ? as i understand this is not a steps of execution but "number of times statement was parsed...." I just don't understand how it can be fetched 3 times..... Thank You.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 22 2000 - 15:18:38 CDT