Indexed Organized tables.

Printable View

08-01-2003, 04:56 AM
anandkl

Indexed Organized tables.

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
08-01-2003, 05:01 AM
abhaysk

You dont gain any performance gain on Inserts but lag.
08-01-2003, 05:09 AM
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
08-01-2003, 05:20 AM
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?
08-01-2003, 05:59 AM
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.
08-01-2003, 06:00 AM
anandkl

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

regards
anandkl
08-01-2003, 07:58 AM
TomazZ

I think it's good idea. Why don't you test it and post the results.
08-01-2003, 09:08 AM
slimdave

Yeah, it sure sounds like a case for benchmarking.
08-01-2003, 10:35 AM
anandkl

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
08-01-2003, 11:34 AM
marist89

Increase? I doubt it. Try it and let us know.
08-01-2003, 11:55 AM
abhaysk

I wud still say (Heap table & assciated index) would be better than IOT if inserts are heavy.

Any ways, test it on your test db or acceptance db first.

Abhay.
08-01-2003, 12:00 PM
anandkl

Hi Friends,
We would be doing a test, once we measure the performance parameters i would email you all the parameters

Thanks for all your suggestions & help.

regards
anandkl
08-01-2003, 01:09 PM
adewri

Quote:

Originally posted by anandkl
Hi Friends,
We would be doing a test, once we measure the performance parameters i would email you all the parameters

Thanks for all your suggestions & help.

regards
anandkl

Have compared the IOT with simple index on a heap table of 1200000 rows, hardly any difference. Only benifit i saw was space saving that you get by having an IOT.
08-01-2003, 01:42 PM
anandkl

Hi Amar,
Do u also compress on IOT

regards
anandkl
08-02-2003, 07:58 AM
PsudoDBA

Hi

I read somewhere IOT will not help on inserts/update intensive tables. You may better check again

Bhaskara
OCP 9i