k*******1
发帖数: 22 | 1 "Neither the DELETE statement without a WHERE clause nor the TRUNCATE
TABLE statement affect the schema structure of the table or related
objects."
这里的“the schema structure of the table or related objects”是指什么啊？ |
a*******t
发帖数: 891 | 2 columns, index, permission etc
【在 k*******1 的大作中提到】
: "Neither the DELETE statement without a WHERE clause nor the TRUNCATE
: TABLE statement affect the schema structure of the table or related
: objects."
: 这里的“the schema structure of the table or related objects”是指什么啊？
|
k*******1
发帖数: 22 | 3 truncate table了，column names, index, permission都还在的？？？
就是说如果truncate table了以后又想加入数据到这个table，就不用再create table
了，直接
insert就行？？
【在 a*******t 的大作中提到】
: columns, index, permission etc
|
B*****g
发帖数: 34098 | 4 truncate <> drop
table
【在 k*******1 的大作中提到】
: truncate table了，column names, index, permission都还在的？？？
: 就是说如果truncate table了以后又想加入数据到这个table，就不用再create table
: 了，直接
: insert就行？？
|
j*****n
发帖数: 1781 | 5 why don't you try it instead as such question?
table
【在 k*******1 的大作中提到】
: truncate table了，column names, index, permission都还在的？？？
: 就是说如果truncate table了以后又想加入数据到这个table，就不用再create table
: 了，直接
: insert就行？？
|
B*****g
发帖数: 34098 | 6 要厚道
【在 j*****n 的大作中提到】
: why don't you try it instead as such question?
:
: table
|
w*********e
发帖数: 5286 | 7 truncate = delete + commit
except
no DML triggers will be fired in truncate.
you cannot rollback, it removes all rows in a table, but not the schema,
privileges, etc.
truncate is usually much faster than delete cuz it does not need to save all
rows in undo space.
【在 k*******1 的大作中提到】
: "Neither the DELETE statement without a WHERE clause nor the TRUNCATE
: TABLE statement affect the schema structure of the table or related
: objects."
: 这里的“the schema structure of the table or related objects”是指什么啊？
|
G********d
发帖数: 593 | 8
all
undo space 。。。。。
还是说log比较prof一点吧...
【在 w*********e 的大作中提到】
: truncate = delete + commit
: except
: no DML triggers will be fired in truncate.
: you cannot rollback, it removes all rows in a table, but not the schema,
: privileges, etc.
: truncate is usually much faster than delete cuz it does not need to save all
: rows in undo space.
|
c*****y
发帖数: 75 | 9 truncate 不写入log
delete 是一条一条删除 可以恢复的 |
n*******r
发帖数: 425 | 10 truncate ddl
delete is dml
"
truncate = delete + commit
except
no DML triggers will be fired in truncate
"
not true, truncate set hwm back to original points so it cleans up the space
immediately, unless you specify REUSE STORAGE clause |
t********k
发帖数: 808 | 11 truncate = delete + commit ?
are you sure?
truncae also changes the high watermark |
