Do fast full index scans do physical disk reads?

From: <Cherie_Machler_at_gelco.com>
Date: Thu, 06 Sep 2001 12:42:56 -0700
Message-ID: <F001.00385D8E.20010906125037@fatcity.com>

I am confused by the output from tkprof below. An fast full index scan is being performed. However, from the statistics, it looks as thought 649 physical disk reads are being performed. Is that actually the case? Are physical disk reads being done?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

---

Select SD.KS_OBJECTID as CONCEPTID
>From kbowner.KS_SHORTDESCRIPTION SD

Where SD.KS_DESCRIPTIONTYPE = 'CPTNAME' And UPPER(SD.KS_DESCRIPTIONTEXT) = '' call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ----------

---

Parse 1 0.03 0.03 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.30 0.30 649 649 4 0
------- ------ -------- ---------- ---------- ---------- ----------

---

total 3 0.33 0.33 649 649 4 0

Rows Row Source Operation

-------  ---------------------------------------------------
      0  INDEX FAST FULL SCAN (object id 5286)


Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   INDEX   GOAL: ANALYZED (FAST FULL SCAN) OF 'SYS_C001069' (UNIQUE)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Cherie_Machler_at_gelco.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 Thu Sep 06 2001 - 14:42:56 CDT