Skip to Main Content

Inserts into IOTs

Sekar_BLUE4EVERMay 7 2015 — edited May 8 2015

I have been reading lot of stuff about about inserts into IOT's being slow as they are organised and oracle has to search the block where to insert the row.

But isn't it essentially same as a  insert into a heap table with a separate primary key index?here the row is inserted anywhere in tablw but still oracle has to find the block to insert into the index so shouldn't both be the same?

Comments
Post Details
Added on May 7 2015
3 comments
111 views