First page Back Continue Last page Graphics
Continuation of Notes
This is a full page of notes.
The slide is hidden.
Notes:
Supplemental Notes
Starting with Oracle8, the ROWID is stored in base-64 format for expanded addressability:
data object number . file number. block number. row number
OOOOO . FFF . BBBBBB . RRR
This format requires 10 bytes of internal storage and 18 bytes if converted to character data.
Oracle provides a ROWID hint that will cause Oracle to use the ROWID, if possible, to retrieve the rows requested:
SELECT /*+ ROWID (tablename) */