Whether used together with access to SQL tables or used separately, this can greatly simplify application development.
无论是与对sql表的访问一起使用,还是单独使用,这都可以大大简化应用程序开发。
Before access path selection, the DB2 optimizer transforms SQL statements into forms that are semantically identical, such as by using predicate pushdown or predicate transitive closure.
在选择访问路径之前,DB 2优化器将sql语句转换成语意上一致的形式,例如使用谓词下推或谓词传递闭包。
The developer can now improve the SQL (or work with the DBA to do so) and repeat the cycle until the SQL USES a desired access path.
现在,开发人员能够改进SQL(或与DBA合作完成)并重复此周期,直到SQL使用了期望的访问路径。
应用推荐