使用EXPLAIN命令查看查询的解释计划。
请选择是查看查询,还是修改查询设计。
请选择查看查询结果还是修改查询设计。
Do you want to view the query results, or modify the query design?
为了查看查询的结果,您可以使用以下的请求url。
至此,一切设置完毕,您可以在输出文件夹中查看查询结果。
At this point, everything is set up and you can take a look at the query results in the output folder.
查询解释使用EXPLAIN命令查看查询的解释计划。
Query Explain Use EXPLAIN command to see the explain plan of a query.
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.
用户可一次处理数个查询,通过几种模式编辑查询,观察运算结果,以及执行任何其它需要的操作。能查看查询计划。
You can work with several queries at once, edit queries and view the execution results in several modes and perform any other operations you may need in your work with database queries.
当您安装了查询表插件之后,像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.
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.
用户能够轻易的创建查询来查看他们自己的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.
应用推荐