which one is faster? truncate or delete?# Database - 数据库
c*t
1 楼
SQL Server:
truncate table blah
vs
delete blah
which one is faster? and why?
truncate table blah
vs
delete blah
which one is faster? and why?
s*n
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?
a transaction.
【在 c**t 的大作中提到】
: SQL Server:
: truncate table blah
: vs
: delete blah
: which one is faster? and why?
aw
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.
【在 s******n 的大作中提到】
: Truncase is way faster if u have a big table because it's not part of
: a transaction.
相关阅读
Oracle 8i InstallationIs "Dim mydb as database" a user-defined datatype用Servlet显示数据库里的数据,分页的? (很实际的问题)Re: 蒙古国土荒漠化严重How to insert a string into table? Thanksdatabase triggers急：为何ACCESS中数据export为.txt文件后格式丢失？ODBC API header file?how to roll backAbout write/read binary files in PBHelpSQL Server restore(transferred from other DB) error... HELP!请推荐关于PHP和mySQL实现小database的网站。傻问题. 瘟98里面sql server的服务器端可以运行吗?Zachary+CA-Clipper ---> MS SQL Server问个关于JDBC和MySQl的问题has anyone used jConnect with Sybase?how to use c language to implement Access Database operations?关于oracle的一个问题!help: SQL Server数据同步复制