Trace Evaluation

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infy.com>
Date: Mon, 25 Jun 2001 04:56:41 -0700
Message-ID: <F001.003361F4.20010625044528@fatcity.com>

Is there Any Scope for Improvement in the Following ?

select acct_crncy_code into :b0
from
GAM where acid=:b1

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

Parse 1 0.00 0.00 0 0 0 0
Execute 73710 3.49 4.60 0 0 0 0
Fetch 73710 4.93 4.82 0 294840 0 73710
------- ------ -------- ---------- ---------- ---------- ----------

total 147421 8.42 9.42 0 294840 0 73710

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

Rows Execution Plan
------- ---------------------------------------------------

      0  SELECT STATEMENT   GOAL: CHOOSE
      0   TABLE ACCESS (BY INDEX ROWID) OF 'GENERAL_ACCT_MAST_TABLE'
      0    INDEX (UNIQUE SCAN) OF 'IDX_GENERAL_ACCT_MAST_TABLE' (UNIQUE)

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

NOTE - IDX_GENERAL_ACCT_MAST_TABLE is Defined on Field ACID of GAM Table

--

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 also send the HELP command for other information (like subscribing). Received on Mon Jun 25 2001 - 06:56:41 CDT