-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|