谁能帮我解释以下语句 谢谢
谁能帮我解释以下语句 谢谢QUERY PLAN FOR STATEMENT 1 (at line 1).
STEP 1
The type of query is UPDATE.
The update mode is deferred_varcol.
FROM TABLE
invt09_c
Nested iteration.
Using Clustered Index.
Index : invt09_c_x
Forward scan.
Positioning by key.
Keys are:
com_idASC
Using I/O Size 2 Kbytes for data pages.
With LRU Buffer Replacement Strategy for data pages.
TO TABLE
invt09_c
Using I/O Size 2 Kbytes for data pages.
(return status = 0) 更新invt09_c ,在匹配时使用了集群索引invt09_c_x的com_id字段,使用了2k的缓冲池 谢谢版主
页:
[1]