Listing 5. View Query definition for the Viewer perspective.
清单5.查看者透视图的视图查询定义。
The Navigation Tree and View Query definitions for the Viewer perspective are shown in Listings 4 and 5, respectively.
查看者透视图的导航树和视图查询定义分别显示在清单4和5中。
The definition files for the perspective, the Navigation Tree, the Collection View, the Detail View, and the View Query were created for the Viewer perspective.
为查看者透视图创建了透视图、导航树、集合视图、详细信息视图和视图查询的定义文件。
It can be a complex query or a view, as described in this article.
正如本文中所描述的,它可以是复杂查询或者视图。
Set this custom query as the default view.
将这个定制的查询设为默认视图。
Of course, you cannot explicitly create or drop these system catalog tables, but you can query and view their content.
当然,不能显式地创建或删除这些系统编目表,但是可以查询和显示这些表的内容。
XML: Create and manage XML database objects, and query and view XML data.
XML:创建并管理XML数据库对象,以及查询并查看XML数据。
Even choosing only a subset of the columns from the view would be a simple SQL query.
即使是只从视图中选择列的一个子集,也能用一个简单的SQL查询实现。
Using the same sample data just discussed above, the following illustrates the difference in cardinality estimates with and without the use of statistical view for the query.
下面使用以上讨论的相同的示例数据,阐释在使用和不使用查询的统计视图的情况下基数估计的差别。
Enter a query in the Asset search view.
在资源搜索视图中输入一项查询。
You can query this view to obtain a dependency summary for the MQTs that we have created (Listing 5).
您可以查询这个视图,获得对我们创建的MQT(清单5)的依赖关系的总结。
If you try the CONSTRUCT query, view the page source to see the full response.
试验CONSTRUCT查询的时候,在资源页面上可以看到完整的响应。
Exposing the relational columns helps to query this view efficiently.
暴露关系列有助于有效地查询这个视图。
The original query against the UNION ALL view is now simplified to a query against one single nickname.
UNIONALL视图上的初始查询现在被简化为对一个昵称的查询。
A query view USES a formula that evaluates to an SQL query to populate its data, instead of using a view selection formula.
查询视图使用SQL查询公式来填充数据,而不是使用视图选择公式。
To view the query access plan using the optimization profile created, the SET CURRENT optimization profile statement can be used in combination with the SET CURRENT EXPLAIN MODE statement, as follows.
要查看使用了创建的优化配置文件的查询访问计划,可以结合使用SETCURRENTOPTIMIZATIONprofile语句和SET CURRENTEXPLAINMODEstatement,如下所示。
To determine if asynchrony was enabled within a federated query, view the access plan of the query using db2exfmt,Visual Explain or a tool of your choice.
要确定一个联邦查询中是否启用了异步,可以使用db2exfmt、VisualExplain或您选择的其他工具来查看查询的访问计划。
The EXPLAIN tool, which requires the existence of the EXPLAIN tables, can be used to view the query access plan chosen by the optimizer. To create the EXPLAIN tables, execute.
EXPLAIN工具可以用于查看优化器选择的查询访问计划,要使用该工具需要有explain表。
Select TAX1120VIEW, and click Add to add the view to the query.
选择TAX1120VIEW 并单击Add,向查询添加一个视图。
A query view is dynamic, and the SQL query will be re-executed every time the Domino view is refreshed (see figure 2).
查询视图是动态的,每当Domino视图刷新时将重新执行SQL查询(参见图2)。
If the remote view contains a complex query, using table-level statistics such as the cardinality for the nickname over the view can be misleading.
如果远程视图包含一个复杂的查询,那么使用表级统计信息(例如视图昵称的基数)可能使人产生误解。
You can either call the function directly, or create a view based on this statement and then query the view.
可以直接调用此函数,也可以根据这个语句创建视图,然后查询视图。
For statistical view, the ENABLE query optimization clause will cause the view, and its associated statistics to be used to improve the query optimization.
对于统计视图,ENABLEQUERYoptimization子句将导致该视图以及与之相关联的统计信息被用于改进查询优化。
The query compiler expands view definitions into the main statement block, which might result in a more complex statement.
查询编译器将视图定义展开成主语句块,从而产生一个更复杂的语句。
Applications were seen as a way to view and query the database's underlying model.
应用程序被看作查看和查询数据库底层模型的方式。
With the view in place, constructing the source query is a snap.
视图就绪后,构造数据源查询就是小事一桩。
编辑新的查询视图。
查询视图。
Existing views cannot be converted into Query views; you must specify that a view is a Query view at the time the view is created.
不能将现有的视图转换为查询视图;必须在创建视图的时候指定该视图为查询视图。
Figure 3 shows a high level view of the query tables needed for this application and how they relate to the physical tables or views in the BPEDB database.
图3显示了一个应用程序所需要的查询表的高级视图,以及如何关联 BPEDB 数据库中的物理表或视图。
应用推荐