TABLE ACCESS (BY USER ROWID)

Description

Retrieves rows from a table using the ROWID.

Versions

This operation was introduced in Oracle 8.0 replacing TABLE ACCESS (BY ROWID)

This operation is implemented in the following versions

8.0.4
8.0.5
8.0.6
8.1.5
8.1.6
8.1.7
9.0.1
9.2.0
10.1.0
10.2.0

Example

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'