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.