请选择是查看查询,还是修改查询设计。
请选择查看查询结果还是修改查询设计。
Do you want to view the query results, or modify the query design?
至此,一切设置完毕,您可以在输出文件夹中查看查询结果。
At this point, everything is set up and you can take a look at the query results in the output folder.
DB 2提供的GUI和命令行工具可以用来查看查询的解释计划。
DB2 provides GUI and command line tools to see explain plan of a query.
在第2部分中,我将深入这个过程,查看查询本身,并查看一些示例。
Part 2 will take you deeper into the process. We'll look at the queries themselves, and examine some examples.
在这一步中,需要挖掘上面所收集的统计数据,并仔细查看查询执行计划。
At this step, you need to dig into the statistics you collected above and take a good look at the query execution plan.
得到EXPLAIN输出之后,查看查询的结果集是如何生成的,然后考虑是否可以采用其他访问路径。
Once you have the EXPLAIN output, look at how the query's result set is generated, and then consider alternative access path possibilities.
在您不使用任何一款rational脚本工具的情况下,这对于查看查询结果和记录测试结果来说已经足够了。
It is adequate for viewing query results and for recording test results when you aren't using one of Rational's scripting tools.
在您不使用任何一款rational脚本工具的情况下,这对于查看查询结果和记录测试结果来说已经足够了。
Adequate for viewing query results and for recording test results when you aren't using one of Rational's scripting tools.
验证可疑性能瓶颈的一个方法是查看查询的运行时统计数据,这可以通过打开IFCID 318上的性能跟踪获得。
One way to validate the suspicious performance bottleneck is by looking into the runtime statistics of the query, which can be obtained by turn on the performance trace on IFCID 318.
您可以通过查看查询中的最小时间项,以及查询中处理一个项目所需要的平均时间,来访问任意查询的效果。
You can assess the effect of any queue by looking at the minimum time items are in the queue, as well as the average time taken to process an item in the queue.
当您安装了查询表插件之后,像PA71 GettingStarted文档描述的那样,您可以查看查询表构件,它是项目交换的一部分。
After you installed the query table plug-in, as described by the PA71 Getting Started document, you can view the query table artifacts that are part of the project interchange.
要确定一个联邦查询中是否启用了异步,可以使用db2exfmt、VisualExplain或您选择的其他工具来查看查询的访问计划。
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.
要理解这一点,查看在此谓词的查询注释上的MAXFREQ。
To understand this, look at MAXFREQ in the query annotation for this predicate.
这是一个简单的界面:输入您的查询,查看结果。
It's a simple interface: type in your query, see the results.
随后,我们可以查看图1,其中展示了这个查询计划的等效符号树表示形式。
We can then examine the equivalent symbolic tree representation of this query plan in Figure 1.
XML任务:创建并维护具有XML数据的表和视图;创建并调优xML索引;查询并查看XML文档;存储并管理XML模式文档。
XML tasks: create and maintain tables and views with XML data; create and tune XML indexes; query and view XML documents; store and manage XML schema documents.
XML任务:创建并维护具有XML数据的表和视图;创建并调优xML索引;查询并查看XML文档;存储并管理XML模式文档。
XML tasks: creating and maintaining tables and views with XML data; creating and tuning XML indexes; querying and viewing XML documents; storing and managing XML schema documents.
现在,让我们来定义一些示例数据和表,以查看具体的查询示例。
Now, let's define some sample data and tables so that we can look at concrete query examples.
XML:创建并管理XML数据库对象,以及查询并查看XML数据。
XML: Create and manage XML database objects, and query and view XML data.
生成访问计划,查看优化器对该查询返回的总基数(行数)的估计值。
Generate the access plan and see what the optimizer estimates the total cardinality (Number of rows) returned by the query will be.
您可以查看配置结果集的查询限制,以得到关于结果设置界限的更多信息。
For more information about result set limitations, see Configuring query limits on result sets.
这一点可以通过查看这样一个查询的原生SQL看出。
This can be seen by examining the native SQL of such a query.
应用程序被看作查看和查询数据库底层模型的方式。
Applications were seen as a way to view and query the database's underlying model.
注意,使用浏览器作为查询工具是查看 HTTP请求的原始JSON应答的一种极其简单的方式。
Notice that using your browser as your query tool is an especially easy way to view the raw JSON response of an HTTP request.
用户能够轻易的创建查询来查看他们自己的CTC,因此他们能够轻易的看到哪些需要被执行。
Users can easily create queries to view their own CTCs, thus they can easily see what needs to be executed.
游标是一种常见的数据库抽象,允许逐行查看和处理查询的结果。
Cursors are a common database abstraction that allow programs and you to view and, thereby, process the results of a query one row at a time.
在我们的企业中,这意味着查看企业名录并查询特定建筑物中固定位置内的所有员工。
In our organization, that means accessing the enterprise directory and performing a query to find all employees with a defined location in a particular building.
因此,程序要通过MQI进行查询,所需的只是查看进程或名称队列中的信息。
Therefore all a program needs to be able to do through the MQI is to view the information in the process or namelist.
使用数据库明细(databaseprofiling)工具来查看在查询的时候使用了什么索引,在更新的时候整个表没有被上锁。
Use a database profiling tool to see what indexes are being used when querying, and that entire tables are not being locked when doing updates.
应用推荐