Table Access By Index Rowid

From: <jaysingh1_at_optonline.net>
Date: Fri, 13 Aug 2004 11:04:07 -0400
Message-id: <485b4d44857846.4857846485b4d4@optonline.net>

    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_at_freelists.org 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

---

Received on Fri Aug 13 2004 - 10:01:11 CDT