Saturday, January 31, 2015

Truncate Vs Delete

Hi


I have a data for year 2013, 2014 and billions of records are there. I want to delete data for 2014. If I do truncate it is going to be faster but it will delete entire data for 2013 as well which I don't want however I just wanted to know is there any alternate solution for making delete faster.




Aniruddha http://ift.tt/1y9OHsc


No comments:

Post a Comment