RE: Temp tables and logging

2004-02-09 Thread Anhaus, Thomas
Mark Fisher wrote : >Thanks for the response. >I have a couple of follow up questions: >Is the undo log only written to if in the middle of a transaction? >Can you think of any other reason why deactivating redo logging would >cause temp table writes to run faster if they have no effect? >Than

RE: Temp tables and logging

2004-02-05 Thread Mark Fisher
Thanks for the response. I have a couple of follow up questions: Is the undo log only written to if in the middle of a transaction? Can you think of any other reason why deactivating redo logging would cause temp table writes to run faster if they have no effect? Thanks. > > >Hello, > > > >I

RE: Temp tables and logging

2004-02-05 Thread Hahn, Uwe
-Original Message- From: Mark Fisher [mailto:[EMAIL PROTECTED] Sent: Thursday, February 05, 2004 12:24 PM To: [EMAIL PROTECTED] Subject: Temp tables and logging >Hello, > >I noticed that when I try deactivating "redo" logging (as a test), >writing data to temp tables seems to happen fast