Re: Large Index organized tables: just a marketing feature ?! (for experts)

From: ChetWest <chetwest_at_yahoo.com>
Date: 8 Sep 2003 06:25:55 -0700
Message-ID: <47c93e56.0309080525.671500af@posting.google.com>

andkovacs_at_yahoo.com (Andras Kovacs) wrote in message news:<412ebb69.0308190849.2eb2584a_at_posting.google.com>...
> Finally I managed to build the test case and there is a bug opened on
> this issue. The bug is 3088833. Basically we can't load massive data
> into an IOT :(
>
> select, import causes the same problem. Index splitting ....

Thanks Andras, this is basically the same issue I was having. I just thought I was doing something wrong. I was loading 40 million records, which were just area code and phone numbers, and it was taking hours. But I could load into a hash table in under 15 minutes. Knowing that there are problems with IOTs on Tru-64 helps out a lot.

Chet Received on Mon Sep 08 2003 - 08:25:55 CDT