"Guido Konsolke" <Guido.Konsolke_at_triaton.com> wrote in message
news:1049199121.332966_at_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.
Table contains rows through 6 months, but major mass of queries
runs only on the last month data.
Received on Tue Apr 01 2003 - 08:34:00 CST
