Re: Partitioning -- good? cost?

From: Keith Boulton <boulkenospam_at_globalnet.co.uk>
Date: Sat, 25 Apr 1998 16:13:29 GMT
Message-ID: <354744ad.9359072@read.news.global.net.uk>

On Wed, 22 Apr 1998 18:07:08 +0800, Connor McDonald <mcdonald.connor.cs_at_bhp.com.au> wrote:

>- unload old data to file (easy and quick)
>- delete old data (easy and incredibly slow)
>- reorg table to reclaim free space

> (easy but no 24x7 !!!)

I'm currently working on a system using partition views. It makes life painful for updates and inserts. In this case, it was done because of the time taken to delete data on a quarterly basis.

I believe it would have been better to delete one day's data each night as part of batch processing which would easily have been fast enough. The only problem I can see is that indexes may need to be rebuilt every so often. Received on Sat Apr 25 1998 - 11:13:29 CDT