This tells me that I may have an inefficient access path, where DB2 reads more data than it should.
这就说明我可能有一个低效的访问路径,DB 2读取的数据比应该读取的数据更多。
Optimized for one problem: By their nature, hierarchical databases optimized access to the data through one specific path.
针对单个问题的优化:本质上,层次数据库就通过一条指定的路径来优化数据访问。
Although the DB2 optimizer is helpful for selecting the best access path, the result depends on the input data, which is often not accessed or controlled by the optimizer.
尽管DB 2优化器对选择最佳访问路径有所帮助,但结果还是依赖于输入数据,优化器无法访问或控制这些数据。
From a performance point of view, a good performing access path should touch the least amount of data with respect to the final result set.
从性能的角度来看,一个良好表现的访问路径相对于最终的结果集应该触及最少的数据量。
The rest of this section takes you through the access path graph one more time from the data flow perspective so that you can gain a full understanding of the performance aspect of query execution.
本节的其余部分再一次以数据流的观点向您介绍访问路径图以便您可以在查询执行的性能方面获得充分的理解。
Access plan describes the access path that the DB2 optimizer has chosen for accessing data for an SQL statement.
访问计划描述访问路径,这些路径是DB 2优化器为sql语句访问数据而选择的。
An appropriate access path means that an index is available and used so that the index drives the access to the data.
恰当的访问路径意味着一个索引可用并且已使用,所以该索引能够方便地对该数据进行访问。
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.
此外,数据库可以更好地理解它存储的数据的状态,从而可以生成到数据的更有效和动态的存取路径。
Static SQL in DB2 is a powerful capability that can streamline data access at run time by doing some of the work ahead of time, such as determining the database access path.
DB 2中的静态SQL是一个强大的功能,可以通过预先执行某些工作来简化运行时的数据访问,例如确定数据库访问路径。
Data flows from the bottom up (as displayed in the graph) and is processed by operation nodes in the access path graph.
数据从下往上流动(如访问路径图所示)并通过访问路径图上的操作节点处理。
The SQL compiler USES them to transform a statement into a more optimized form, thus improving the access path to the required data.
SQL编译器使用信息约束将语句转化成更优的形式,从而改善对所需数据的访问路径。
To access the data, give the path of the attribute you want to access.
要访问数据,请提供需要访问的属性所在的路径。
Central tools terminate that administrative access path onto specific hosts in a secured data center, which then mediate access through a lightweight client, such as a browser.
集中工具终止安全数据中心中特定主机上的管理访问路径,这随后将利用中介传递通过轻量级客户机(如浏览器)进行的访问。
Without column data-value distribution information in the catalog, DB2 will assume an even distribution of values, which may lead the optimizer to a sub-optimal access path.
如果编目中没有列数据值分布信息,DB 2就会假设值是均匀分布的,这可能导致优化器选择非最优的访问路径。
Having the DBMS determine the optimal access path to the data lifts a heavy burden off the programmer's shoulders.
让DBMS确定到数据的最优存取路径解除了程序员肩上沉重的负担。
This implementation style is useful to remove duplicates and provide (in many cases federated) a consistent access path to master data.
这种实现风格有助于消除重复的数据并(在许多情况下通过联合)提供一致的主数据访问路径。
Keep in mind that this catalog data is what the optimizer USES to make access path decisions.
请记住,优化器使用编目数据决定访问路径。
After you decide on the DDL option, you need to provide the file name and full path for it so Rational Data Architect can access it (Figure 35).
决定了DDL选项后,需要提供文件名和文件的完整路径,以便RationalDataArchitect能访问到它(图35)。
WebSphere Federation Server USES its cost based optimizer in order to determine the optimal access path to retrieve and process the data.
WebSphereFederationServer使用它的基于成本的优化器,确定检索和处理数据的最佳路径。
Without correct column distribution statistics, DB2 may not have enough information to make the best choice when choosing an access path to the data-especially if data is heavily skewed.
在选择数据的访问路径时,如果没有正确的列分布统计数据,DB 2可能没有足够的信息来做出最佳的选择,尤其是如果数据出现严重误差。
An access path graph not only describes the "operational details" of query execution, it also describes how the data flows.
访问路径图不但描述“操作细节”,而且描述数据如何流动。
In order to establish efficient access path, the authors put forward a structure index for XML data, and introduce a method of implementing operations based on structure index.
为了建立高效地访问路径提出了一种XML数据的结构索引,并介绍了利用结构索引实现基本的数据操作的方法。
In order to establish efficient access path, the authors put forward a structure index for XML data, and introduce a method of implementing operations based on.
为了建立高效地访问路径提出了一种XML数据的结构索引,并介绍了利用结构索引实现基本的数据操作的方法。
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.
该硬盘还配备有8M的多分段的数据缓冲区与一个32位宽的内部数据更快的数据存取路径相结合。
The access rate of the memory is determined by crucial path which is between data input and data output.
静态存储器的存取速度由地址输入到数据输出的关键路径决定。
The access rate of the memory is determined by crucial path which is between data input and data output.
静态存储器的存取速度由地址输入到数据输出的关键路径决定。
应用推荐