Next, collect statistics so that the system tables will be populated.
接下来,收集统计信息,这样系统表中会出现一些数据。
The ability to use SQL to query metadata from a standard set of system tables
使用SQL从一组标准系统表查询元数据的功能
The following operations can be performed under the System Tables section
可以在System Tables 区域下执行下列操作
Specifies whether or not direct updates are allowed against system tables.
指定是否允许直接对系统表进行更新。
The syscdc system database in IDS contains the change data capture functions and system tables.
IDS 中的 syscdc系统数据库包含变更数据捕捉函数和系统表。
We can get this information by querying two system tables; systables and sysindexes. Here is the query.
可以通过查询两个系统表来获得这方面的信息:systables和sysindexes。
In this section you can query existing system tables, set a filter for the tables, or display the system tables.
在这个部分中,您可以查询现有的系统表、设置表过滤器或显示系统表。
The statement must not reference system tables or views including catalog views and dynamic management views.
语句不能引用系统表或视图,包括目录视图和动态管理视图。
All further communication with the data source is performed using native queries to the system tables of the data source.
数据源之间所有深层次的交流都是使用数据源系统表的本地查询来实现的。
Even if the database is newly created and still empty, system tables and views are always present, so you can use them as follows.
即使数据库是新创建且仍然为空的,也总是会带有系统表和视图,因此,您可以按以下方法使用它们。
This is because there are several internal system tables that are used to control the objects alongside tables that contain the data.
这是因为要用几个内部系统表与包含数据的表一起来控制对象。
Most SQL-compliant databases, including SQL Server, store metadata in a series of system tables with the names sysobjects, syscolumns, sysindexes, and so on.
与SQL 兼容的大多数数据库(包括 SQLServer)将元数据存储在名为sysobjects、syscolumns、sysindexes 等的一系列系统表中。
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将检查编目表(在某些数据库系统中也称系统表),并根据该信息创建数据模型。
This script will read the Informix system tables, find out which tables have page-level locking, and then generate another SQL script to change those tables to row-level locking.
此脚本将读取Informix系统表,找出哪些表具有页面级锁定,然后生成另一段sql脚本来将这些表更改为行级别锁定。
Of course, you cannot explicitly create or drop these system catalog tables, but you can query and view their content.
当然,不能显式地创建或删除这些系统编目表,但是可以查询和显示这些表的内容。
The RUNSTATS utility updates statistics in the system catalog tables to help with the query optimization process.
RUNSTATS实用程序用于更新系统目录表中的统计信息,以帮助查询优化过程。
STATCHANGE is the percentage change threshold value for all tables in your system.
STATCHANGE是指系统中所有表的修改阈值,采用百分比形式。
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.
数据模型中的关键元素是一组统计信息,该统计信息收集了有关数据库中所包含的数据和系统目录表中所存储的数据的信息。
Update system catalog tables that the database server USES to optimize queries.
更新数据库服务器用于优化查询的系统编目表。
System-wide locking tables are often considered to be hotspots.
系统级的锁定表通常被认为是系统中的热点。
A set of system catalog tables is created and maintained for each database.
对于每个数据库,都创建和维护一组系统编目表。
The database server does not update the statistics in the system catalog tables.
数据库服务器不更新系统编目表中的统计信息。
The database manager creates and maintains two sets of system catalog views that are defined on top of the base system catalog tables.
数据库管理器创建和维护两组系统编目视图,这些视图是在基本系统编目表之上定义的。
To ensure fast recovery of the partition containing system catalog tables, avoid placing user tables on the same database partition.
为了确保包含系统编目表的分区能够快速恢复,应避免将用户表也放在那个数据库分区上。
In a relational language, such a query would require a join that might span several data tables and system catalog tables.
而在关系语言中,这种查询需要进行也许跨越了多个数据表和系统目录表的联接。
The DB2 UDB system catalog is a collection of tables that describe database objects.
DB 2udb系统编目是描述数据库对象的表的集合。
The SYSSTAT schema contains a small number of updatable views that are based on the system catalog tables.
SYSSTAT模式包含少量的基于系统编目表的可更新视图。
System catalog tables reside in the same dbspace as the database itself.
系统目录表和数据库本身位于同一个dbspace中。
System database changes: New tables sysusermap, syssurrogategroups, and syssurrogateusers are added to the sysusers database.
系统数据库变更:在sysusers数据库中添加新的表格sysusermap、syssurrogategroups和syssurrogateusers。
System catalog base tables (SYSIBM schema)
系统编目基表(SYSIBM模式)
应用推荐