存取路径 access path ; access s path
存取路径选择 [计] access path selection
存取路径加宽 [计] access path widening
存取路径控制 [计] access path control
数据存取路径 data access path
随机存取路径 [计] random access path
键序存取路径 keyed sequence access path
多路存取路径 [计] multiple access path
到达顺序存取路径 arrival sequence access path
逻辑存取路径网络 logical access path network
它如何选择在优化存取路径中使用这些策略中的哪一个?
How does it choose which of these strategies to use in the optimized access paths?
这意味着优化器将始终尝试为每个查询制定减少总体成本的存取路径。
This means the optimizer will always attempt to formulate an access path for each query that reduces overall cost.
此外,数据库可以更好地理解它存储的数据的状态,从而可以生成到数据的更有效和动态的存取路径。
In addition, the database can have a better understanding of the state of the data it stores, and thereby can produce a more efficient and dynamic access path to the data.
应用推荐