The query compiler performs two major categories of rewrite
查询编译器主要可以执行两种类型的重写
The query compiler uses these characteristics and restrictions when planning the query.
当计划查询时,查询编译器使用这些特征和约束。
When the query is submitted, its syntax and semantics are analyzed by the query compiler.
当提交该查询时,查询编译器会分析它的语法和语义。
If indexes are created on the CGTT table, the query compiler will take those indexes into account.
如果为cgtt表创建了索引,则查询编译器会将这些索引考虑在内。
The SQL statements and commands submitted in a pass-through session do not go through the federated query compiler.
在pass - through会话中提交的sql语句和命令不会通过联邦查询编译器。
The federated query compiler makes a cost-based decision and makes the process of using MQTs transparent to the users.
联邦查询编译器作出一个基于成本的决策,并使得使用MQT的过程对用户是透明的。
The query compiler expands view definitions into the main statement block, which might result in a more complex statement.
查询编译器将视图定义展开成主语句块,从而产生一个更复杂的语句。
The query compiler uses this information while checking any character comparison operations, to decide how to evaluate the operations.
查询编译器在检查字符比较操作时使用该信息,以决定如何执行操作。
To process the query, the DB2 query compiler consults information in the DB2 federated database system catalog and the data source wrapper modules.
为了处理该查询,DB 2查询编译器查阅DB 2联邦数据库系统编目中的信息以及数据源包装器模块中的信息。
To process the query, the DB2 query compiler consults information in the DB2 federated database system catalog and the data source wrapper modules.
为了处理该查询,DB 2查询编译器查阅DB 2联邦数据库系统编目中的信息以及数据源包装器模块中的信息。
应用推荐