delete vs truncate
I deleted 8 million records from one table using delete statement, it tooks 30min to finish the operation.
I truncated same records using Truncate table statement in fraction of second.
Truncate is faster as it has not to check the constrains unlike delete. Truncate will give you fresh copy of table with all seed maaped to its default index.
Satalaj
Currently rated 5.0 by 1 people
- Currently 5/5 Stars.
- 1
- 2
- 3
- 4
- 5