Capacity planning for VERY large table

From: Michael Bialik <michael_bialik_at_my-deja.com>
Date: Mon, 25 Sep 2000 20:22:05 GMT
Message-ID: <8qoc4j$cfc$1@nnrp1.deja.com>

Hi.

I have a very large table ( 25 * 10**9 rows = 25,000,000,000 rows ). The row length is 60 bytes, so the table size is 1.5Tb - 2.0 Tb ( including Oracle overhead ).

The table contains 24 numeric fields and 1 description. Each numeric field ( F01, F02, ... F24 ) may contain values from 0 to 255 only.

The SELECT is going to look like that:

   SELECT description FROM large_table
   WHERE
    F01 between 24 and 44 AND
    F02 between 66 and 86 AND
    F03 between 1 and 21 AND
    ...
    F24 between 235 and 255.

Does anybody worked with such big tables? What response time ( with what type of computer ) may I expect? Is it possible to achieve 1 second response time with Oracle ( 8i )? On what computer?

TIA. Michael

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 25 2000 - 15:22:05 CDT