Hi guys,
I need Help to a problem I have, I know when we delete a lot of rows in a table, the SQL register all of them in the Register Transaction, because it use it to back changes if something fails, but what happen if i need to delete 100,000,000 rows, it can be stressfull, because it take a lot of time register each row that was deleted.
I also know about TRUNCATE TABLE, and that it's a faster way to delete rows, but it is the type of sentece i don' t need.
Are there any way to disable Register Transaction, or Are there any way to execute this sentence much faster too.
Thanks a lot