Table access by index rowid VS Unique Index Scan
Hi,
could someone please shed some light on as to what is the difference between
A) operation = "Table Access" , Options = "by index row id"
and
operation = "index, options = "unique scan" --> as reported in DBA_HIST_SQL_PLAN
Doesn't UNIQUE INDEX access means looking up the index root branch, traverse through to the leaf block, get the rowid of the data in the table and access it? If thats true, then wouldn't this be "Table Access By Index RowID"? If yes, then how does this differ from "unique index scan"
thanks
could someone please shed some light on as to what is the difference between
A) operation = "Table Access" , Options = "by index row id"
and
operation = "index, options = "unique scan" --> as reported in DBA_HIST_SQL_PLAN
Doesn't UNIQUE INDEX access means looking up the index root branch, traverse through to the leaf block, get the rowid of the data in the table and access it? If thats true, then wouldn't this be "Table Access By Index RowID"? If yes, then how does this differ from "unique index scan"
thanks
0