This will allow both of the following queries to use indexed access rather than table scans.
这将允许下面两个查询来使用索引访问,而不是表扫描。
Supports iteration and indexed access.
支持迭代和索引访问。
It will choose indexed access if it has lower cost than table scan.
如果使用索引的开销比表扫描的开销低,优化器将选择索引访问。
Overall - it's definitely a good thing. In practice, you may see a much stronger bias towards indexed access paths which may impact performance.
总之——这肯定是一个好事。事实上,你可以发现对索引访问路径更强的偏好,这将影响性能。
In the Indexed Access method, a method of indicating that a record or block is in use and is not available for another request.
在索引存取方法中,指明一个记录或数据块处于使用之中而且不再接受另一个使用请求的一种方法。
In the Indexed Access method, a method of indicating that a record or block is in use and is not available for another request.
在索引存取方法中,指明一个记录或数据块处于使用之中而且不再接受另一个使用请求的一种方法。
应用推荐