I purposely interrupt one of the access paths by pulling off an FC cable between the host and switch.
我故意拔掉主机与交换机之间的一根 FC电缆,从而中断其中一条访问路径。
As a result, it can improve the possible access paths.
从而,它能提升可能的访问路径。
The easiest way to describe access paths is to use an example.
描述访问路径最容易的方法是使用示例。
These different ways are known as access paths or access plans.
这些不同的方法就是众所周知的访问路径或访问计划。
The sort heap size is used by the optimizer in determining access paths.
优化器用排序堆大小来确定存取路径。
It is efficient, as the indexes qualify for the choice of excellent access paths.
它高效,因为索引适合于最佳访问路径的选择。
How does it choose which of these strategies to use in the optimized access paths?
它如何选择在优化存取路径中使用这些策略中的哪一个?
This article described the basic concepts of access paths and how to read an access path graph.
本文描述了访问路径的基本概念以及如何解读访问路径图。
Clustering analysis is based on calculating the similarity degree of the user access paths.
对客户进行聚类分析是建立在对用户浏览路径进行相似程度计算的基础上的。
Then I purposely interrupt one of the access paths by pulling off an FC cable between the host and switch.
然后,我故意拔掉主机与交换机之间的一根 FC电缆,以中断其中一条访问路径。
Then I purposely interrupt one of the access paths by pulling off an FC cable between the host and switch.
然后,我故意拔掉主机与交换机之间的一根FC电缆,以中断其中一条访问路径。
Refer to the previous article of this series for more information about reading and understanding access paths.
请参考本系列之前的文章,了解更多阅读和理解访问路径的文章。
Similar customer groups, relevant WEB pages and frequent access paths can be discovered by analyzing of WEB log files.
通过对WEB服务器日志文件进行分析,可以发现相似的客户群体、相关WEB页面以及频繁访问路径。
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.
优化器使用该数据模型来估计可以用于解决某个特定查询的其它存取路径的成本。
This section illustrates how the query Tuner query annotation and access path graph can help you analyze access paths and SQL performance.
本部分说明QueryTuner查询注释和访问路径图如何帮助您分析访问路径和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.
您还需要学习如何最好地编写这些SQL语句以及如何发现DB2选择的存取路径来满足您的 SQL请求。
Before SQL is executed, the DB2 optimizer estimates the cost of the candidate access paths and selects the path with the least estimated cost.
在执行SQL之前,DB 2优化器会评估候选访问路径的成本,然后选择成本最低的路径。
Listing 9 contains the same three-way join SQL statement that was used in Listing 1 to introduce the concept of access paths and query execution.
清单9包含相同的三路联接sql语句,其用在清单1上以介绍访问路径和查询执行的概念。
Overall - its definitely a good thing. In practice, you may see a much stronger bias towards indexed access paths which may impact performance.
总之——这肯定是一个好事。事实上,你可以发现对索引访问路径更强的偏好,这将影响性能。
Overall - it's definitely a good thing. In practice, you may see a much stronger bias towards indexed access paths which may impact performance.
总之——这肯定是一个好事。事实上,你可以发现对索引访问路径更强的偏好,这将影响性能。
Overall - it's definitely a good thing. In practice, you may see a much stronger bias towards indexed access paths which may impact performance.
总之——这确定是一个好事。事实上,你能够觉察对索引拜会路径更强的溺爱,这将波及功能。
Also, before selecting the access path, the optimizer first performs a series of query transformations to increase the number of access paths available.
还有,在选择访问路径之前,优化器首先会执行一系列查询转换以增加可用访问路径的数目。
For a given SQL statement, there are often multiple access path choices, and the different access paths usually have different performance characteristics.
对于一个给定的sql语句,往往有多个访问路径选择,而不同的访问路径具有不同的性能特点。
Although different access paths for the same SQL statement produce the same result set, they most likely do not perform the task with the same level of performance.
虽然相同sql语句的不同访问路径会产生相同的结果集,但是它们很有可能不会通过同样的性能级别来执行任务。
If all the data access paths in the application are executed, then the captured information contains the complete list of SQL statements that are issued to the database.
如果应用程序中的所有数据访问路径都被执行,那么捕获的信息将包含向数据库发出的完整sql语句列表。
In the mining procedure no candidate generation is required, and only one time, we can obtain all the continuous access paths that take the root of IWAP-Tree as suffix.
采用这种方法进行挖掘,无需生成候选集,而且一次就可以挖掘出所有以根节点为后缀的连续频繁访问路径。
Insufficient or inaccurate statistics lead to inaccurate cost estimates for the candidate access paths and is the most common reason for the selection of inefficient access paths.
不充分或不准确的统计数据会导致对候选访问路径评估不准确,这也是选择低效访问路径的最常见原因。
Even if the number of rows in a table remains consistent, changes in data contents can result in different, and hopefully better, access paths using statistics updated by RUNSTATS.
即使表的行数保持一致,使用由RUNSTATS更新的统计信息来更改数据内容可以产生不同的、也许更好的访问路径。
After the SQL is captured, you can use the full power of Optim Development Studio for modifying the SQL, visualizing access paths, conducting performance testing, and doing impact analysis.
捕捉SQL之后,您可以使用Optim DevelopmentStudio的完整功能修改SQL、可视化访问路径、执行性能测试并进行影响力分析。
It is essential to consider the possible access paths to every layer of a system, and also to consider how authorization integrates with other security aspects, such as network level protection.
务必考虑系统的每个层次的可能访问路径,同时还要考虑授权如何与其他安全功能(如网络级别的保护)集成。
应用推荐