Oracle-L: Re: Index - To use OR Not ?

From: Greg Moore <sqlgreg_at_pacbell.net>
Date: Tue, 13 Aug 2002 13:49:03 -0800
Message-ID: <F001.004B3A90.20020813134903@fatcity.com>

process size limitation on HP-UX>> Qs. How is the Number of Block Visitations to be Found for Both the Index Scan & Full Table Scan ?

You could use Autotrace. That will show blocks read, indicating logical and physical reads. You could also use TKPROF.

Original Message ----- From: VIVEK_SHARMA To: Multiple recipients of list ORACLE-L Sent: Tuesday, August 13, 2002 6:33 AM Subject: Index - To use OR Not ?

Gaja Wrote in his Book 101 Performance Tuning

"When Running an SQL Query Avoid using Indexes when an index scan performs More Block Visitations Than a Full Table Scan"

Qs. How is the Number of Block Visitations to be Found for Both the Index Scan & Full Table Scan ?

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Greg Moore
INET: sqlgreg_at_pacbell.net

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 Tue Aug 13 2002 - 16:49:03 CDT