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 noticed that when I try deactivating "redo" logging (as a test), > >writing data to temp tables seems to happen faster. Is it correct to > >assume that even temp table writes are logged in SAP-DB? > > No, it isn't. Operations on temp tables only write undo log > which resides in the data area. > > Kind regards, > Uwe -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
