Re: deleting large number of records from table...

On Mon, 17 Nov 1997 11:14:45 +0000, Steve Haynes <steve_at_rwx777.demon.co.uk> wrote:

>We run a monster warehouse where we have to design to truncate
>partitions because the day isn't long enough to delete.

Yes. I know what you mean. In the case I mentioned earlier in the thread we found a way around this, though. (It might have been better to do it your way, but when I came into the project the database was already designed :-( )

>Therefore, when a table is partitioned correctly, you can delete from
>a table selectively by truncating a partition.

Doing a little magic here ... ;-)

Heber

---
hferraz_at_via.at