Table Access By Index Rowid

From: jaysingh1@xxxxxxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
Date: Fri, 13 Aug 2004 11:04:07 -0400

    Hi All,

I have a question reg. "Table Access By Index Rowid"
This is part of my explain plan from tkprof output.

    833      TABLE ACCESS BY INDEX ROWID TAB2 
   2838       INDEX RANGE SCAN DESCENDING (object id 1174163)
    832      TABLE ACCESS BY INDEX ROWID TAB1 
   1664       INDEX UNIQUE SCAN (object id 5840)

5840 is a Primary Key index.

My question is why does the index returned 1664 rows instead of 832 rows (it is 
a unique index)?

I want to read 832 records instead of 1664 reacords.

Any help would be highly appreciated.

Thanks
Jay

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Follow-Ups:

Re: Table Access By Index Rowid
From: Wolfgang Breitling

Table Access By Index Rowid

Other related posts: