现在的位置: 首页 > 综合 > 正文

physical rowid and logical rowid

2018年04月17日 ⁄ 综合 ⁄ 共 436字 ⁄ 字号 评论关闭

physical rowid represent one row in heap table(other table except IOT).

IOT(index organized table) use physical rowid to represet one row to fulfill the same usage. this rowid was calcuated by oracle by using some hash fucnion based on primary key

 

rowid impact after UML.

physical rowid isn't changed after DML update.

logical rowid is changed since the primary key changed.

 

 

rowid impact after table move/shrink space

physical rowid is changed

logical rowid is changed and the physical guess will become stale. 

 

 

抱歉!评论已关闭.