Multiple choice technology databases

Which Oracle access method is the fastest way for Oracle to retrieve a single row?

  1. Primary key access

  2. Access via unique index

  3. Table access by ROWID

  4. Full table scan
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Table access by ROWID is the fastest method because ROWID is the physical address of the row in the database. Accessing via ROWID requires a single direct I/O operation to locate the row. Primary key access and unique index access require traversing the index structure first, then accessing the table. Full table scan is the slowest as it reads every row.

Keep practicing — related questions