which one is faster? truncate or delete? - Database版 - 未名存档

本页内容为未名空间相应帖子的节选和存档，一周内的贴子最多显示50字，超过一周显示500字访问原贴

Database版 - which one is faster? truncate or delete?

相关主题
● delete	● truncate和delete在ORACLE里有什么区别?
● INSERT or UPDATE, which is faster?	● 如何让SQL 2005 CLR Trigger返回结果给Stored Procedure用?
● Re: Is there any easy way to truncate the LDF file of SQL SERVER?	● 新手一问，关于delete和truncate table
● Truncation error import csv file to SQL table	● SQL Servedr complete recovery question
● Is there any easy way to truncate the LDF file of SQL SERVER?	● How to delete 40 millions records in a 400 millions indexed table fast?
● Access 'memo' data type	● Re: 菜人问问，你们都在database上干什么？？ (转载)
● SQL 2005 Intergration Service Q	● 什么时候不用索引
● error file或者exception file	● 想做几个SQL development的project

相关话题的讨论汇总
话题: truncate话题: faster话题: delete话题: blah话题: server

进入Database版参与讨论

1

(共1页)

c**t 发帖数: 2744	1 SQL Server: truncate table blah vs delete blah which one is faster? and why?
s******n 发帖数: 45	2 Truncase is way faster if u have a big table because it's not part of a transaction. 【在 c**t 的大作中提到】 : SQL Server: : truncate table blah : vs : delete blah : which one is faster? and why?
aw 发帖数: 127	3 so the loss will not be recoverable, be careful. 【在 s******n 的大作中提到】 : Truncase is way faster if u have a big table because it's not part of : a transaction.

1

(共1页)

进入Database版参与讨论

相关主题
● 想做几个SQL development的project	● Is there any easy way to truncate the LDF file of SQL SERVER?
● How to make import (>200M) faster?	● Access 'memo' data type
● SQL Server stupid questions	● SQL 2005 Intergration Service Q
● how to particially delete record in sql server	● error file或者exception file
● delete	● truncate和delete在ORACLE里有什么区别?
● INSERT or UPDATE, which is faster?	● 如何让SQL 2005 CLR Trigger返回结果给Stored Procedure用?
● Re: Is there any easy way to truncate the LDF file of SQL SERVER?	● 新手一问，关于delete和truncate table
● Truncation error import csv file to SQL table	● SQL Servedr complete recovery question

相关话题的讨论汇总
话题: truncate话题: faster话题: delete话题: blah话题: server

未名新帖统计// 7月16日

#	版面	帖数(主题数)
-	全站	4871 (796)
1	Military	3777 (569)
2	Stock	341 (51)
3	Joke	117 (17)
4	History	116 (3)
5	Automobile	100 (9)
6	USANews	55 (9)
7	Midlife	45 (1)
8	Headline	41 (41)
9	Dreamer	33 (13)
10	FleaMarket	32 (20)
11	Living	30 (7)

* 这里只显示发帖超过25的版面，努力灌水吧:-)