Re: Index organized table

From: Epicentre Team B Annecy <carmanet_at_epicentre.fr>
Date: Wed, 15 May 2002 17:02:44 +0200
Message-ID: <abtta0$nqb$1@wanadoo.fr>

Hi Ive,

No, this table is definitively not a good candidate for INDEX ORGANIZED TABLE!
Indeed, indexes severely degrade insert performances, so I let you see with an index organized table...

OTH.

--
Celine Armanet
EPICENTRE
carmanet_at_epicentre.fr
Tel. : +33 04 50 09 7000
"lve" <lve3162_at_yahoo.com> a écrit dans le message news:
93096888.0205150620.68aa6cf7_at_posting.google.com...


> I have a table in an OLTP database which is subject to very frequent

> inserts. The table has a sequential number column which is the primary

> key of the tables.  Rows are almost never deleted from this table-

> they are, of course, archived every couple of months.

>

> Is this table a good candidate for INDEX ORGANIZED TABLE?

> I am using oracle 8.1.7

>

> thanks

>

> lve

Received on Wed May 15 2002 - 10:02:44 CDT