RE: tkprof Output Puzzle

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Wed, 25 Oct 2000 10:10:58 +0400
Message-Id: <10659.120133@fatcity.com>

Hi Vivek,

Try to replace N with another bind variable in

ENTITY_CRE_FLG='N' . I am not very sure of it, but it should work.

HTH,
Rajesh

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of VIVEK_SHARMA
Sent: Wednesday, October 25, 2000 10:10 AM To: Multiple recipients of list ORACLE-L Subject: tkprof Output Puzzle

Why is the Parse Count So High even when Unique index is being used ?

NOTE Unique index IDX_INTEREST_DETAILS_TABLE on IDT ( entity_id, entity_type, interest_ind, interest_type, serial_num )

Am a Novice of sorts

select entity_id ,entity_type ,interest_ind ,interest_type ,serial_num from
IDT where ((ENTITY_ID=:b0 and ENTITY_TYPE=:b1) and ENTITY_CRE_FLG='N')

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ----------

Parse 122 0.06 0.02 0 0 0 0
Execute 122 0.00 0.00 0 0 0 0
Fetch 122 0.04 0.63 178 1042 0 0
------- ------ -------- ---------- ---------- ---------- ----------

total 366 0.10 0.65 178 1042 0 0

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 12 (TBAGEN)

Rows Execution Plan

-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
     18   TABLE ACCESS (BY ROWID) OF 'INTEREST_DETAILS_TABLE'
     19    INDEX (RANGE SCAN) OF 'IDX_INTEREST_DETAILS_TABLE' (UNIQUE)




************************************************************************

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: VIVEK_SHARMA
  INET: VIVEK_SHARMA_at_infy.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Wed Oct 25 2000 - 01:10:58 CDT