🎴 Flashcard Mode
Database Management Fundamentals: SQL Server and IMS
Card1 / 12
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 is the physical disk address of a row, so accessing by ROWID is the fastest method - Oracle goes directly to the exact location. Primary key and unique index require traversing an index structure first, and full table scan reads every row in the table.