Re: Capacity planning for VERY large table

From: Steve Long <steven.long_at_erols.com>
Date: Mon, 25 Sep 2000 23:27:16 -0400
Message-ID: <8qp4sd$ocg$1@bob.news.rcn.net>

you should seriously consider using a bitmap index.

"Michael Bialik" <michael_bialik_at_my-deja.com> wrote in message news:8qoc4j$cfc$1_at_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 - 22:27:16 CDT