ITPub博客

首页 > IT基础架构 > 网络安全 > Rowids of Row Pieces (158)

Rowids of Row Pieces (158)

原创 网络安全 作者:tsinglee 时间:2007-11-07 11:42:20 0 删除 编辑

The rowid identifies each row piece by its location or address. After they are assigned,
a given row piece retains its rowid until the corresponding row is deleted or exported
and imported using Oracle utilities. For clustered tables, if the cluster key values of a
row change, then the row keeps the same rowid but also gets an additional pointer
rowid for the new values.
Because rowids are constant for the lifetime of a row piece, it is useful to reference
rowids in SQL statements such as SELECT, UPDATE, and DELETE.

行片段的rowid
1. rowid 唯一标识每个行片段的存储位置和地址
2. 每个行片段得到一个 rowid 之后 , 这个值将会保持不变 , 直到其所属行被删除或被导入导出

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-981076/,如需转载,请注明出处,否则将追究法律责任。

下一篇: Column Order (159)
请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1892837