Re: Implementing a large partitioned IOT?

From: Karsten Schmidt <groups_at_karsten-schmidt.com>
Date: 8 Feb 2002 04:00:05 -0800
Message-ID: <c6711ac4.0202080400.5afba76a@posting.google.com>

Mark,
i got a database with a partitioned, key-compressed iot, that grows by about 7 million rows per day.

I ran into a couple of bugs with parallel query, and/or secondary indexes on that table, but they were all related to data-loads. So it has been easy to implement workarounds.

Apart from that, everything is fine.

One thing to watch out for, make sure you get the storage parameters right the first time. For some reason you cannot change them later on. Yes, there is syntax for that, but that does not seem to work.

BTW, this is 8.1.7 on HP, 64Bit.

Karsten

"Mark J. Bobak" <mark_at_bobak.net> wrote in message news:<pan.2002.02.08.01.21.30.700497.13851_at_bobak.net>...
> D'oh. I should have mentioned, this is 8.1.7 EE on
> Solaris.
> On Fri, 08 Feb 2002 00:34:40 -0500, Mark J. Bobak wrote:
>
Received on Fri Feb 08 2002 - 06:00:05 CST