Indexed Organized tables.

[anandkl]

Hi Friends,
We are planing to migrate a table to index organised table, the table has two columns and forms a perfect match for IOT.This table is higly insert/delete table.I want to know if we migrate this table to IOT will we benefit in insert performance i.e will the time taken by insert be reduced. I also read in oracle documentation the we can COMPRESS the index keys, we are planing to implement this, will this have any impact in insert performance.

Please help...

regards
anandkl

[abhaysk]

You dont gain any performance gain on Inserts but lag.

[anandkl]

Why,
Since it would be using the same block to store data and index, so it should be much faster

please explain your answer.

regards
anandkl

[TomazZ]

I think it should be little faster than
inserting in regular table and maintaining a separate index alltogether.

But, is this table big enough that it needs an index at all?

[abhaysk]

Insert into heap organised table ( No assciated indexs ) Vs IOT, which one will be faster?

The Q was inserting into normal table ( before ) and later conerting to IOT, which one will be faster. I guess former one.

Abhay.

[anandkl]

Hi Tom,
For every week we will inserting close to 2 Million records

regards
anandkl

[TomazZ]

I think it's good idea. Why don't you test it and post the results.

[slimdave]

Yeah, it sure sounds like a case for benchmarking.

[anandkl]

Hi Friends,
I am sorry if i have confused you, actually the existing table is a table which index as well.So if we convert this into IOT, would insert performance increase.

I am sorry if i have confused you people.

regards
anandkl

[marist89]

Increase? I doubt it. Try it and let us know.