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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
