IOT Secondary Indexes – The Logical ROWID Guess Component Part I (Lucky)

(Richard Foote) As discussed previously, an index entry within a Secondary Index on an Index Organized Table (IOT) basically consists of the indexed column(s) and the Logical Rowid, the PK column(s) and a “guess” to the physical block in the IOT containing the corresponding row.

Read More - Register for Free Membership