Oracle: Index Unique Scan & Index Range Scan

摘自《Troubleshooting Oracle Performance》

Index Unique Scan: 针对唯一性索引,只返回一个rowId

Index Range Scan: 用于非唯一性索引,可以返回多个rowId

Leave a Comment

Your email address will not be published.

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