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.