ITPub博客

首页 > IT基础架构 > 网络安全 > How Rowids Are Used

How Rowids Are Used

原创 网络安全 作者:tsinglee 时间:2007-11-22 15:22:13 0 删除 编辑

Oracle uses rowids internally for the construction of indexes. Each key in an index is associated
with a rowid that points to the associated row's address for fast access. End users and application
developers can also use rowids for several important functions:

Rowids are the fastest means of accessing particular rows.
Rowids can be used to see how a table is organized.
Rowids are unique identifiers for rows in a given table.

Before you use rowids in DML statements, they should be verified and guaranteed not to change. The
intended rows should be locked so they cannot be deleted. Under some circumstances, requesting data
with an invalid rowid could cause a statement to fail.

You can also create tables with columns defined using the ROWID datatype. For example, you can
define an exception table with a column of datatype ROWID to store the rowids of rows in the
database that violate integrity constraints. Columns defined using the ROWID datatype behave like
other table columns: values can be updated, and so on. Each value in a column defined as datatype
ROWID requires six bytes to store pertinent column data.

[@more@]

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

上一篇: Examples of Rowid Use
下一篇: Logical Rowids
请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1900330