Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Oracle index scan

2025-04-01 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Index unique scan: is for the unique index scan, it is only applicable to the where condition is the target SQL of the equivalent query, because the scanning object is the unique index, only scan the index height of so many index blocks to stop, the index unique scan results return at most one record, index unique scan, scan index height-2 branch blocks, always scan only one leaf block.

Index range scan: index range scan, scan index height-2 branches fast, to scan N multi-leaf blocks, depending on where conditions, index range scan is single block read, because physical storage is discontiguous. Select * from test where id select / * + index_desc (test) * / * from test where object_id

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report