Indexed Organized tables.

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.

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

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.

Hi Amar,
Do u also compress on IOT

regards
anandkl

Hi

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

Bhaskara
OCP 9i