Oracle: 通过rowid获取数据行是效率最高的方式

摘自《Troubleshooting Oracle Performance》

通过rowid获取数据行是效率最高的方式

典型的场景是: 

   1. select rowid from t where xx =xx

   2. update t set yy=yy where rowid = xxx

Leave a Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.