Re: 30GB table: Hardware performance issue ?

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