Which one faster- With Rowid or PK
500237Apr 23 2008 — edited Apr 24 2008Hi,
Recently came across the concepts of IOT(Index organised table). It was mentioned that
"
You must specify a primary key for an index-organized table, because the primary key uniquely identifies a row. Use the primary key instead of the Rowid for directly
accessing index-organized rows. "
This surprised me as till date I was assuming that the fastest way to access the data from a table is by Rowid. Isn't this contadicting then?
Can the experts clarify more on these conceps related to IOT.
Rgds,
Aashish