answersLogoWhite

0

For performance. Truncate will release the tablespace used by the table that the data is being removed from and delete will not release this space.

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

How do you differentiate between truncate and delete?

TRUNCATE and DELETE: It also removes the rows from the specified location in the query like DELETE command, but the only difference is : 1. rows once u truncated cnnot be ROLLBACKED like in DELETE. 2. which ROLLBACK can be possible with delete. 3. Truncate is used for HUGE databases or tables bcz it works efficiently. 4. DELETE will work efficiently on small data(tables). Now it is vident that the only difference between TRUNCATE and DELETE is efficiency(i.e,Accessing Speed). Annapurna. TRUNCATE REMOVES ALL THE ROWS FROM THE TABLE AND CANNOT BE Rollbacked, while delete removes all/specific rows from table and can be rollbacked. Also truncate resets the high water mark. A common misconception is that they do the same thing. Not so. In fact, there are many differences between the two. DELETE is a logged operation on a per row basis. This means that the deletion of each row gets logged and physically deleted. You can DELETE any row that will not violate a constraint, while leaving the foreign key or any other contraint in place. TRUNCATE is also a logged operation, but in a different way. TRUNCATE logs the deallocation of the data pages in which the data exists. The deallocation of data pages means that your data rows still actually exist in the data pages, but the extents have been marked as empty for reuse. This is what makes TRUNCATE a faster operation to perform over DELETE. You cannot TRUNCATE a table that has any foreign key constraints. You will have to remove the contraints, TRUNCATE the table, and reapply the contraints. The difference between the two is that the truncate command is a DDL operation and just moves the high water mark and produces a now rollback. The delete command, on the other hand, is a DML operation, which will produce a rollback and thus take longer to complete. Truncate can be rollbacked,, basically i see lot of aritcles which says it can rollback,, but the truth is that we can rollback after trancate ,, difference is that in truncate only deallocation of the data page is done, but in delete the it is logged in deleted table and is physically removed from data page,,, Harishjan The difference is with operation on memory because if you want to have a place in memory for a later use you should use delete but if you want clear memory you should use truncate - this function clears the value and place where this value was stored. For more detailed explanation about this topic please read the following article. http://www.sqlservercentral.com/articles/delete/61387/


How do you delete what you have searched on WikiAnswers?

when the drop down menu comes down scroll your mouse over it and press the delete button on the keyboard ---------------------------------------------------------------------------------------------------------------------------------------------------------- OMG THANKYOU SOOO MUCH!!!!!!! XXXXXXXXXXX


How do you end a facebook chat on an ipod?

You ca slide your finger over it to the left and press delete (like when deleting notes or other things from a list.) Hope this helps K


How can I delete a file that won't delete?

Go to the YouTube video I am linking to below. Or search for "file won't delete" in the search there, more than one way to do it. First of all, I've tried deleting it by dragging it to the recycling bin, which doesn't work. I've tried Shift+Del on it, and it doesn't work. I've even booted my computer in safe mode with command prompt and tried deleting it with the command prompt, and it doesn't work. Every time I try deleting or even moving it, it just shows the load window, but doesn't have the bar moving... It stays like this. I've tried leaving it on over night, and nothing is different. I'm on Windows Vista. Help!


What is the URL to delete your gaia avatar?

Log into Gaia Online. Hover over MY GAIA and then go to ACCOUNT SETTINGS. Scroll down until you see AVATAR GENDER. Then in the paragragh, you will see DELETING YOUR AVATAR which is in blue with an underline. Click on that.


How do you delete all photos from memory stick?

On your camera, go to the menu. Then, find the option that says Format. Select the Format option. When it asks you to continue, select yes. Next it will say that it is busy deleting all of the pictures. This is much faster and easier than what Arkanada suggested. -Mengjing you just keep pressing delete over and over until all of the pictures are deleted.


What is the use of Backspace and Delete keys?

They are for deleting things, mainly text but also other items on your document like graphics. The Delete key removes the character to the right of the cursor, or anything that is selected. The backspace removes the character to the left of the cursor, or anything that is selected.


Can you start Pokemon white over without deleting your other profile?

No.


How do you permanatly delete a Facebook account?

go to account click on it. go down and click on account settings. go down click on deactivate account.go over click on deactivate. either pick why you are deleting your account or explain why. then click on deactivate my account.


How do you delte your Twitter?

To delete your entire Twitter account, click on settingson the top right hand side of your profile. Then, scroll to the bottom of the page it takes you to and click on delete account.If you want to delete any of your tweets, hover over the tweet and click on delete. You can't delete other people's tweets.


How do you get over your ex if he thinks the ending of the relationship is your fault?

If you want to get over him you should try not to talk about him and hang out with your friends alot now. Also try deleting his number from your phone, delete him from your myspace, facebook, ect... and get rid of the things he gave to you if you really want to get over him. So what he thinks it's your fault. If you know it's his fault that's all the matters.


How do you delete facebook login emails?

You put your curser over the email you want to delete and press the delete button on your keyboard.