The RUNSTATS utility updates statistics in the system catalog tables to help with the query optimization process.
RUNSTATS实用程序用于更新系统目录表中的统计信息,以帮助查询优化过程。
In a relational language, such a query would require a join that might span several data tables and system catalog tables.
而在关系语言中,这种查询需要进行也许跨越了多个数据表和系统目录表的联接。
This article can only provide a brief introduction as the event catalog would on its own require a further article to describe how users can add, remove, and query event definitions and categories.
本文仅作简短介绍,因为事件目录本身需要更多的文章来描述用户如何添加、删除和查询事件定义和类型。
Of course, you cannot explicitly create or drop these system catalog tables, but you can query and view their content.
当然,不能显式地创建或删除这些系统编目表,但是可以查询和显示这些表的内容。
An entry is added to the system catalog to indicate to the query optimizer that such a remote index exists.
一个条目被添加到系统编目中,以向查询优化器表明存在那样的一个远程索引。
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联邦数据库系统编目中的信息以及数据源包装器模块中的信息。
Find the package and section information for the main query from the catalog tables.
从目录表中查找主查询的包和片段信息。
To properly assess these access path alternatives, you'll need information from the DB2 catalog about the tables accessed by the query and the indexes defined on those tables.
为了正确地评估这些访问路径,需要从DB 2编目中获取关于查询访问的表以及这些表上定义的索引的信息。
The optimizer USES the following system catalog information as it creates a query plan.
当优化器创建查询计划时,它将使用下列系统目录信息。
That CmisJpg class contains property definitions for some of the common Exif values that she might query during a search through her catalog of images.
这个CmisJpg类包含某些常用exif值的属性定义,这位摄影师可能会在搜索她的图像目录时查询这些值。
This method of generating the explain data is very useful when debugging a static query whose packages are stored in the catalog tables.
这种生成explain数据的方法对于调试一个将包存储在目录表中的静态查询是很有用的。
You can also query this catalog with the help of Windows' standard search tool.
也可以在Windows标准搜索工具的帮助下查询此目录。
To get the name of the index with ID 3, query the SYSCAT.INDEXES catalog view using a SELECT statement, as shown in Listing 12.
要获得ID3索引的名称,请使用SELECT语句查询 SYSCAT.INDEXES目录视图,如清单 12 所示。
One quick way to see whether RUNSTATS has been performed on your database is to query some system catalog tables. For example, as shown in the script above, you can run this command.
要查看是否对数据库执行了RUNSTATS,一种快捷方法便是查询一些系统目录表。
To find out all accounts with privileges, you can query each of the system catalog views and combine the results together using the UNION operator, as shown in Listing 4.
要查明具有特权的所有帐号,可以查询每个系统编目视图并使用UNION操作符将结果组合在一起,如清单4所示。
The runstats utility can be used to update statistics in system catalog tables to facilitate the query optimization process.
可以使用runstats实用程序来更新系统编目表中的统计信息,使查询优化过程更容易一些。
You can use Dublin Core to catalog all sorts of information in an effective manner that is both easy to update and easy to query and use.
DublinCore可以有效地对各种信息编目,并且使它们易于修改、查询和使用。
The query optimizer USES the SYSSTAT catalog views in the database to retrieve the statistical information of the database objects and determine the best way to access the data.
查询优化器使用数据库中的SYSSTAT目录视图来检索数据库对象的统计信息,并确定访问数据库的最佳方法。
This can be verified by executing a query against the DB2 catalog views SYSCAT.TABLES and SYSCAT.TABLESPACES.
可以通过对DB 2编目视图syscat .TABLES和SYSCAT . TABLESPACES执行查询来确认这一点。
To demonstrate the patterns in the catalog, I use an aspect that implements search-term highlighting (that is, highlighting a user's query terms in the search results).
为了展示这个编目中的样式,我使用了一个实现突出显示搜索术语(即在搜索结果中突出显示用户的查询术语)的方面。
Using these query strings, we can navigate our way through the catalog of products.
运用这些查询字串,我们可以对整个产品类目进行导航。
By iterating through the list of objects returned from the JMX query, the code prints out a nicely formatted list of catalog servers by name and includes the hostname where they are running.
通过遍历从JMX查询返回的对象列表,代码将按名称输出恰当设置了格式的目录服务器列表,并包括所在主机的主机名。
By iterating through the list of objects returned from the JMX query, the code prints out a nicely formatted list of catalog servers by name and includes the hostname where they are running.
通过遍历从JMX查询返回的对象列表,代码将按名称输出恰当设置了格式的目录服务器列表,并包括所在主机的主机名。
应用推荐