Non-matching index scan (IXSCAN)
非匹配索引扫描 (IXSCAN)
Typically, a non-matching index scan is chosen by the optimizer when the underlying index provides benefits such as index-only access, avoids sort, or some similar benefit.
通常情况下,在基础索引提供好处(如唯一索引访问、避免排序或一些类似的好处)时,可通过优化器选择非匹配索引扫描。
An index scan can be non-matching, which means that there are no restrictions in the scan of the underlying index.
索引扫描可以是非匹配的,这意味着在基础索引的扫描上没有限制。
An index scan can be non-matching, which means that there are no restrictions in the scan of the underlying index.
索引扫描可以是非匹配的,这意味着在基础索引的扫描上没有限制。
应用推荐