Re: How datas can be handled in Big database

From: Jan-Peter Meyer <jan-peter.meyer_at_mch20.sbs.de>
Date: Tue, 11 Jan 2000 15:00:31 +0100
Message-ID: <387B377F.66FF2A3_at_mch20.sbs.de>


The best way of handling your problem would be to use partitions. This will increase your query performance if you give the optimizer the chance to identify when only current data is needed to answer a query. You can further reduce backup time if you set the tablesspace of your "old" data to read-only whenever it is "frozen"

Fither Muhammed schrieb:
>
> Hi
>
> We want to manage a database containing more than 1 GB
> data. The data base containing 54 tables. In this database
> most of the space is occupied by 5 tables. Only the datas
> of the last six months are needed for usual operations. But
> the data before Six months are needed for annual reports.
> Can we improve the performance by taking the backup of old
> records(before six months) and delete the same from the
> database ? Can we restore the old data from this back up
> if there is a need for that? What are the
> Techiniques/Methods used for this ?
>
> We are using NT4.0/ORACLE 8
>
> Thanks - Fither Muhammed
>
> * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful
Received on Tue Jan 11 2000 - 15:00:31 CET

Original text of this message