Re: need advice for partitioning in 8.1.7.2

From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Tue, 1 Apr 2003 14:14:55 +0200
Message-ID: <1049199121.332966@news.thyssen.com>

"Ragnar Hark" wrote...
> Hi all !
>
> What is a best way to partition already existing table ?
>
> For example;
> I have a table which contains about 80000000 rows and
> each row contains timestamp. So, I think the best solution
> is partition data by months.
>
> sorry, if this message send twice
> ragnar.hark_at_mail.ee
>

Hi Ragnar,

what time span do the data cover? What are the usual queries that are used (where clause)? Give us a little more information.

Bye,
Guido Received on Tue Apr 01 2003 - 06:14:55 CST