🎴 Flashcard Mode
Oracle PL/SQL and SQL Fundamentals
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Which Oracle access method is the fastest way for Oracle to retrieve a single row?
AnswerClick to flip back
A
Table access by ROWID
💡 Explanation:
ROWID provides the fastest access because it contains the exact physical address of the row in the database file (data block, row position). Primary key access and unique index access require index traversal first, then table access. Full table scan reads every row, making it the slowest method.