Multiple choice technology databases

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

  1. Primary key access

  2. Full table scan

  3. Access via unique index

  4. Table access by ROWID

  5. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Primary key access is generally the fastest method for Oracle to retrieve a single row because primary keys are unique and have mandatory indexes. When you query by primary key, Oracle can use the index to quickly locate the exact row. Access by ROWID is equally fast when you already have the ROWID, but primary key is typically the standard fastest method. Full table scans are slow for single row retrieval, and unique index access is similar but secondary to primary key access in most scenarios.

Keep practicing — related questions