LOGGING vs NOLOGGING

From: <dougcoan_at_my-deja.com>
Date: Fri, 20 Aug 1999 13:44:01 GMT
Message-ID: <7pjm2u$ojv$1@nnrp1.deja.com>

Ok, This should be a no brainer, but I'm having a mental block on this:

Does anyone have any thoughts on the pros/cons of setting temporary tablespaces to nologging? Does writing to temporary segment even produce redo information? I'm 99.9% sure it does not. If does, pros = speed and reduced log switching. Cons = I can thing of none.

Also, What about setting indexes to nologging and leaving the table in log mode. pros = speed and reduced log switching. Cons = Must rebuild the indexes after recovery.

Any comments welcome. Thanks..........

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 20 1999 - 08:44:01 CDT