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.
相关阅读
怎样从网页上往 英文access数据库输入中文How to load data into Mysql from txt file?我的EA Server怎么回事?database schema 打印问题help on oemapphow to remove oracle completelyHow to connect to Access 2000 database with database password in ODBC要做一个简单的Digital-Library, 能给些Basic的指点吗？Oracle Certificatejdbc to db2 on linux问题为啥SQL server 在win2000 pro 下也能用呢?请教一个数据库设计的问题MySql Question数据库方向的UNIV。？Question to JDBCNew SERVER purchaseA question in class diagram[转载] 急问大峡：怎么把email存进数据库？How to install mysql server on Linux?access 2000 的问题，虚心请教！