Performance, logging with large daily reporting tables
From: Ken Watts <wattsk1_at_midas-kapiti.com>
Date: 13 May 2003 06:22:38 -0700
Message-ID: <147fb29b.0305130522.44019c33_at_posting.google.com>
Date: 13 May 2003 06:22:38 -0700
Message-ID: <147fb29b.0305130522.44019c33_at_posting.google.com>
Hi all,
Cheers
Would like to be able to suppress logging on a handfull of tables used
as extracts to support daily reports. They are cleared before end of
day and then repopulated, I suppose they are really global
temporary/transient tables. On DB2 we use the create and alter
statement clause "ACTIVATE NOT LOGGED INITIALLY" which allows them to
be deleted without being logged. Could drop and recreate the table
rather than just deleting the records, but would appreciate advice on
alternative solutions, and/or which method would be most efficient
with oracle.