| 1. | How does it choose which of these strategies to use in the optimized access paths
它如何选择在优化存取路径中使用这些策略中的哪一个？ |
| 2. | Having the dbms determine the optimal access path to the data lifts a heavy burden off the programmer s shoulders
让dbms确定到数据的最优存取路径解除了程序员肩上沉重的负担。 |
| 3. | This means the optimizer will always attempt to formulate an access path for each query that reduces overall cost
这意味着优化器将始终尝试为每个查询制定减少总体成本的存取路径。 |
| 4. | It analyzes sql statements and determines the most efficient access path available for satisfying each statement see figure 1
它分析sql语句并确定可以满足每条语句的最有效的存取路径（请参阅图1 ） 。 |
| 5. | Ibm does not publish the actual , in - depth details of how the optimizer determines the best access path , but the optimizer is a
Ibm并没有发布优化器如何确定最佳存取路径的真正和深入的详细信息，但优化器是一个 |
| 6. | 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请求。 |
| 7. | 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
参数化查询的主要性能好处是优化器可以制定在重复执行语句时能够再使用的存取路径。 |
| 8. | This is all possible because the physical access paths to db2 data are not coded by programmers in application programs , but are generated by db2
因为到db2数据的物理存取路径并不是由程序员在应用程序中编码的，而是由db2生成的，所以这种情况是完全有可能发生的。 |
| 9. | 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
此外，数据库可以更好地理解它存储的数据的状态，从而可以生成到数据的更有效和动态的存取路径。 |
| 10. | Database guru craig mullins explains the basics of access paths and join methods , and then shows you how you can use tools such as explain to monitor and tune your sql performance
数据库专家craig mullins解释了存取路径和连接方法的基本概念，并展示了如何使用explain之类的工具来监视和调优sql性能。 |
