NoLog

[tanaka]

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.

[Sureshy]

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

[pando]

nologging only works on INSERT

[tanaka]

So whats the use of using nolog.

[ggnanaraj]

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.