Retrieves rows from a table using the ROWID.
This operation was introduced in Oracle 8.0 replacing TABLE ACCESS (BY ROWID)
This operation is implemented in the following versions
|
This is an example of the functionality replaced by TABLE ACCESS (BY USER ROWID)
This example was developed using Oracle 7.3.4
This example requires the following table definition
CREATE TABLE t1 (c1 NUMBER);
The table does not need to be analysed
The statement
SELECT c1 FROM t1 WHERE ROWID = ( SELECT MIN (ROWID) FROM t1 );
generates the following execution plan
0 SELECT STATEMENT Optimizer=CHOOSE 1 0 TABLE ACCESS (BY USER ROWID) OF 'T1' 2 1 SORT (AGGREGATE) 3 2 TABLE ACCESS (FULL) OF 'T1'