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? >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 Please note that it's possible to disable undo logging for temp tables. CREATE TABLE TEMP.TEST (COL1 INTEGER) IGNORE ROLLBACK This of course will speed up dml execution (insert, update, delete). Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
