Re: 30GB table: Hardware performance issue ?

Andras Kovacs wrote:
> I got the problem !
> Here is a solution if somebody has a similar problem:
> - We really had an IO limit on the SCSI driver it was running 90%
> - I modified the index on the table so now it includes the historical value
> The index is IDX_HISTORY( TIME_STAMP, ID, VALUE ).
> The query is running in 6 sec instead of 33sec.
> - The IO rate has fallen dramatically
> - An other good thing, the index has still the same size as before

Sounds like an IOT-constuct...

Apart from that, do you have all that data in one file? I can only see "it's 30GB" but I'm unclear whether it's the table, or the file.
My assumption (correct me if I'm wrong) is that partitioned tables gain a lot from being physically apart; like "you want april 2001 data? I'll give you this file."

-- 
Regards, Frank van Bortel