Deleting from Database Tables using a PRO*C Progr

From: Barry Roomberg <barry.roomberg_at_compudata.com>
Date: Tue, 08 Nov 1994 16:35:00 -0500
Message-ID: <12a.7070.905_at_compudata.com>

-> The Problem is that it runs too slow. It appears to delete between
-> 400,000 and 500,000
-> records in a day - however some of the dates to be deleted have up to
-> 800,000 r ecords.

Play with rollback segment size. Try increasing allocation size.

---

Internet: barry.roomberg_at_compudata.com (Barry Roomberg) This message was processed by NetXpress from Merlin Systems Inc.

---

Received on Tue Nov 08 1994 - 22:35:00 CET