Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Table Access By Index Rowid
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
![]() |
![]() |