Examining the contents of the system catalog tables.
检查系统目录表的内容。
System catalog tables for sampledb reside in Dbdbspace.
sampledb 的数据库目录表位于Dbdbspace 中。
System catalog tables reside in the same dbspace as the database itself.
系统目录表和数据库本身位于同一个dbspace中。
A set of system catalog tables is created and maintained for each database.
对于每个数据库,都创建和维护一组系统编目表。
Update system catalog tables that the database server USES to optimize queries.
更新数据库服务器用于优化查询的系统编目表。
The database server does not update the statistics in the system catalog tables.
数据库服务器不更新系统编目表中的统计信息。
Named SYSCATSPACE by DB2, the catalog table space holds the system catalog tables.
目录表空间被DB 2命名为SYSCATSPACE,它保存了系统目录表。
Note that the new system catalog tables will be dropped during the reversion process.
注意,新的系统目录表将在逆转过程中删除。
The SYSSTAT schema contains a small number of updatable views that are based on the system catalog tables.
SYSSTAT模式包含少量的基于系统编目表的可更新视图。
Regular dbspaces: Regular dbspaces hold database objects like system catalog tables, user tables, and indices.
常规dbspace:常规dbspace用来存放数据库对象,如系统目录表、用户表和索引。
The RUNSTATS utility updates statistics in the system catalog tables to help with the query optimization process.
RUNSTATS实用程序用于更新系统目录表中的统计信息,以帮助查询优化过程。
Of course, you cannot explicitly create or drop these system catalog tables, but you can query and view their content.
当然,不能显式地创建或删除这些系统编目表,但是可以查询和显示这些表的内容。
In a relational language, such a query would require a join that might span several data tables and system catalog tables.
而在关系语言中,这种查询需要进行也许跨越了多个数据表和系统目录表的联接。
The runstats utility can be used to update statistics in system catalog tables to facilitate the query optimization process.
可以使用runstats实用程序来更新系统编目表中的统计信息,使查询优化过程更容易一些。
A large table space named SYSCATSPACE, which is used to store the system catalog tables and views associated with the database.
一个名为syscatspace的大表空间,用于存储与数据库有关的系统目录表和视图。
To ensure fast recovery of the partition containing system catalog tables, avoid placing user tables on the same database partition.
为了确保包含系统编目表的分区能够快速恢复,应避免将用户表也放在那个数据库分区上。
The database manager creates and maintains two sets of system catalog views that are defined on top of the base system catalog tables.
数据库管理器创建和维护两组系统编目视图,这些视图是在基本系统编目表之上定义的。
A key element in the data model is the set of statistics gathered about the data contained in the database and stored in the system catalog tables.
数据模型中的关键元素是一组统计信息,该统计信息收集了有关数据库中所包含的数据和系统目录表中所存储的数据的信息。
Since the update STATISTICS are not run automatically, the System Catalog tables would not be updated and would still be retaining the old statistical data.
由于没有自动运行UPDATESTATISTICS,所以system catalog表没有更新,仍然保留旧的统计数据。
Statistics for objects are updated in the system catalog tables only when explicitly requested. There are several ways to update some or all of the statistics.
只有当进行显式的请求时,对象的统计信息才会在系统目录表中被更新。
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,一种快捷方法便是查询一些系统目录表。
The DB2 UDB system catalog (or simply "catalog") consists of a number of tables and views that are maintained by the database manager.
DB 2udb系统编目(或简称为“编目”)由很多表和视图组成,这些表和视图由数据库管理器来维护。
The DB2 UDB system catalog is a collection of tables that describe database objects.
DB 2udb系统编目是描述数据库对象的表的集合。
System - to store catalog information in system tables.
System——存储系统表中的目录信息。
System catalog base tables (SYSIBM schema)
系统编目基表(SYSIBM模式)
The statement must not reference system tables or views including catalog views and dynamic management views.
语句不能引用系统表或视图,包括目录视图和动态管理视图。
Rational Data Architect will go through the catalog tables, also known as system tables in some database systems, and create a data model based on that information.
RationalDataArchitect将检查编目表(在某些数据库系统中也称系统表),并根据该信息创建数据模型。
Rational Data Architect will go through the catalog tables, also known as system tables in some database systems, and create a data model based on that information.
RationalDataArchitect将检查编目表(在某些数据库系统中也称系统表),并根据该信息创建数据模型。
应用推荐