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.
just because it hasn't recorded the delete in the redo logs, it still has to record the before image in the RBS.
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
nologging only works on INSERT
So whats the use of using nolog.
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.
Click Here to Expand Forum to Full Width