优化器用排序堆大小来确定存取路径。
The sort heap size is used by the optimizer in determining access paths.
它如何选择在优化存取路径中使用这些策略中的哪一个?
How does it choose which of these strategies to use in the optimized access paths?
泛关系模型的目的在于获得完全的存取路径独立性。
The universal relation model aims at achieving the complete access path independence.
这意味着优化器将始终尝试为每个查询制定减少总体成本的存取路径。
This means the optimizer will always attempt to formulate an access path for each query that reduces overall cost.
让DBMS确定到数据的最优存取路径解除了程序员肩上沉重的负担。
Having the DBMS determine the optimal access path to the data lifts a heavy burden off the programmer's shoulders.
它分析sql语句并确定可以满足每条语句的最有效的存取路径(请参阅图1)。
It analyzes SQL statements and determines the most efficient access path available for satisfying each statement (see Figure 1).
优化器使用该数据模型来估计可以用于解决某个特定查询的其它存取路径的成本。
This data model is used by the optimizer to estimate the costs of alternative access paths that can be used to resolve a particular query.
在计划优化模块中,详细讨论了存取路径的选择和代价评估的计算方法。
In plan optimization module, the access path selection and the account method of cost evaluation are discussed in detail.
参数化查询的主要性能好处是优化器可以制定在重复执行语句时能够再使用的存取路径。
The key performance benefit of parameterized queries is that the optimizer can formulate an access path that can be reused over repeated executions of the statement.
本文对数据库的查询技术进行分析,给出两种优化方法:分解查询和选择最优存取路径。
In this paper, first the query technology on database is analysed, then two optimization methods are offered: the disintegration query and the best access path selection.
此外,数据库可以更好地理解它存储的数据的状态,从而可以生成到数据的更有效和动态的存取路径。
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.
通常系统采用基于关系代数操作,请求分解定位和存取路径的优化三种技术对请求进行优化。
The system always adopt three kinds of technology that base on relational algebra operation, request decomposit localization, access route optimization to make optimization.
IBM并没有发布优化器如何确定最佳存取路径的真正和深入的详细信息,但优化器是一个基于成本的优化器。
IBM does not publish the actual, in-depth details of how the optimizer determines the best access path, but the optimizer is a cost-based optimizer.
该硬盘还配备有8M的多分段的数据缓冲区与一个32位宽的内部数据更快的数据存取路径相结合。
The drive is also equipped with an 8MB multi-segmented data buffer combined with a 32-bit wide internal data path for faster data access.
您还需要学习如何最好地编写这些SQL语句以及如何发现DB2选择的存取路径来满足您的 SQL请求。
You'll also need to learn how best to write these SQL statements, and how to discover the access paths DB2 chose to satisfy your SQL requests.
静态存储器的存取速度由地址输入到数据输出的关键路径决定。
The access rate of the memory is determined by crucial path which is between data input and data output.
指定可以在安装时存取,以覆写自订资料夹路径的命名属性,可以在安装时让使用者重新命名资料夹。
Specifies a named property that can be accessed at installation time to override the path of a custom folder, allowing a user to rename the folder during installation.
找不到目录且使用者没有存取管线根路径或增益集路径的使用权限时,所掷回的例外状况。
The exception that is thrown when a directory is not found and the user does not have permission to access the pipeline root path or an add-in path.
找不到目录且使用者没有存取管线根路径或增益集路径的使用权限时,所掷回的例外状况。
The exception that is thrown when a directory is not found and the user does not have permission to access the pipeline root path or an add-in path.
应用推荐