Multiple choice technology databases

Why does a query in Oracle run faster when ROWID is used as a part of the where clause?

  1. None of the below

  2. Both C & D

  3. ROWID is not a physical column.

  4. ROWID is the logical address of a row.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Queries using ROWID in the WHERE clause run faster because ROWID represents the fastest possible access path to a row - it's the logical (pseudo-column) address that points directly to the physical location. When you query by ROWID, Oracle doesn't need to use indexes or scan tables; it goes straight to the specific data block and row slot. ROWID is not a physical column stored in the table, but a pseudo-column that exists in every row automatically. The speed improvement comes from direct physical addressing.

Keep practicing — related questions