NoLog

Hi,

I have a table with 1 million records.If I issue a delete on that table :

Delete table sales_master;

It takes 2.52 minutes , If I issue without logging

Delete table sales_master nolog;

It takes 2.33 minutes and if I truncate it

Truncate table sales_master ;

It takes .01 minute...

Can anyone expain that why nolog takes so much time and after I rollback the data is rolled back without log also.

Thanks.

just because it hasn't recorded the delete in the redo logs, it still has to record the before image in the RBS.

nologging only works on INSERT

So whats the use of using nolog.

Hi

When u have a large amount of rows to be loaded then nolog will speed up the process at the cost of norecoverability as no redo information is generated / stored in the redo logs.