Multiple choice general knowledge sports

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 for Oracle to retrieve a single row because ROWID is the physical address of the row in the database. Accessing directly by physical address avoids the overhead of index traversal or scanning multiple rows. Full table scan is the slowest, while primary key and unique index access are faster than full scans but still require index lookup overhead.

Keep practicing — related questions