Re: Large table design

Create snapshots/materizlied views on top of it and refresh them nightly, those static reports will be available during the day for fast and easy querying.

On Tue, 15 Aug 2000 09:18:21 GMT, goldenge_at_my-deja.com wrote:

>Hi all,
> Our application will use very large table, the table will be
>inserted into more than 400000 records one day. we need to count the
>daily & monthly statistic from this table, how to design this request,
>if anyone have the expirence, please give us some advise,
>We need your help.
>
>Many Thanks.
>Gewuyue.
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
  Received on Tue Aug 15 2000 - 19:56:02 CDT