If the table space is not backed up, tables within that table space can be queried, but not updated.
如果没有备份这个表空间,那么只能对其中包含的表进行查询,而无法更新它们。
Table scope: Identifies which tables are considered for automatic statistics collection.
表范围:确定对哪些表执行自动统计信息收集。
A star join query typically involves a fact table and several dimension tables, with join predicates between the fact table and each dimension table.
一个星型连接查询通常包含一个事实表和几个维度表,事实表和每个维度表之间都有连接谓词。
Database developer — Responsible for the actual databases in operation, including designing databases, schemas, tables, table relationships, and indexes as well as optimizing queries.
数据库开发人员——负责实际运行的数据库,包括设计数据库、模式、表、表关系、索引,以及对查询进行优化。
These objects include schemas, table spaces, tables, indexes, views, packages, routines, sequences, servers, and nicknames.
这些对象包括模式、表空间、表、索引、视图、包、例程、序列、服务器和昵称。
Consider whether having the tables in table Spaces with different Settings is likely to significantly increase performance.
考虑如果让表空间中的表具有不同的设置,是否有可能显著提高性能。
Temporary tables are stored in user temporary table Spaces.
临时表存储在用户临时表空间中。
This implies joins between several dimension tables and the fact table.
这意味着要将几个维表与事实表相联结。
Once tables are distributed among table spaces, you need to determine their physical storage.
一旦将表分布到多个表空间中,就必须决定它们的物理存储器。
Restoring a particular table space first does not improve availability if it contains tables with referential constraints to tables in other table spaces.
如果特定的表空间包含的表与其他的表空间中的表存在引用限制,那么首先恢复它不会改进可用性。
It can be used to compress entire tables, table partitions, and materialized views.
它可以用于压缩整个表、表分区和物化视图。
It contains control block information for tables, indexes, table Spaces, and buffer pools.
它包含表、索引、表空间和缓冲池的控制块信息。
Table scope: Identifies which tables are considered for automatic reorganization.
表范围:确定对哪些表执行自动重组。
You can use these same steps to apply filters on other database objects such as tables, table Spaces, aliases, and sequences.
可以按照相同的步骤对表、表空间、别名和序列等其他数据库对象应用筛选器。
You must create your own table models - plus edit the source code - to set text on textfields, add action listeners to buttons, and set table models on tables.
您必须创建自己的表格模型,并编写相关原代码,设置文本域中的文本,为按钮添加操作监听器,并在表格上设置表格模型。
Often, you may need to create database objects such as databases, tables, or table Spaces to address incoming business requirements.
为了满足业务需求,常常需要创建数据库对象,比如数据库、表或表空间。
The optimizer, in the absence of current statistics, is choosing to do a table scan on both tables involved in the join.
在缺少当前统计的情况下,优化器选择对参与联接的两个表进行表扫描。
All tables which have foreign key relationships to the selected table — and all foreign key tables from the selected table — will be visualized in the diagram illustrated in Figure 7, following.
对所选择的表具有外键关系的所有表——以及来自所选表的所有外键表——将会在下面的图7中被可视化的显示出来。
Only consider user tables for automatic table reorganization.
仅对用户表进行自动表重组。
These sub queries are called derived tables or table expressions.
这些子查询被称作派生表或表表达式。
The from component of a SELECT statement indicates from which table (or multiple tables) the data will be extracted.
select语句的FROM组件指明将从哪个表(或多个表)中提取数据。
Database objects that are lockable are table Spaces, tables and rows, however, only tables and table Spaces can be explicitly locked.
可锁定的数据库对象有表空间、表和行,但是只有表和表空间可以显式地锁定。
User temporary table spaces: User temporary table spaces store declared global temporary tables.
用户临时表空间: 用户临时表空间存储已声明的全局临时表。
Having fined-grained database tables means more table joins and accordingly more complex queries.
细粒度的数据表意味着更多数据表连接,相应的查询也会更复杂。
But in simple terms, a table join creates a composite table from two other tables.
但是用简单的术语来说,一个表格联系会从两个不同的表格创建一个组合表格。
You can write to a table (or multiple tables) with a few commands, and pull data in the same way.
几行命令就能把数据写入表(或者多个表)或者读出来。
Where; you select the columns of interest from rows in a table or tables where certain conditions are satisfied.
您可以从一个或多个表的行中选择您感兴趣的满足特定条件的列。
This provides the table a default order and a fast way to join the table against other tables.
这为表提供一个默认顺序和快速方式来联接其他表。
Select the ACCTPROFILE table from the list of available tables for this schema.
从该模式的可用表格列表中选择acctprofile表。
The reason: Normalization requires more tables, table joins, keys and indexes and thus more internal database operations for implement queries.
其原因是:规范化需要更多的表,连接等操作,主键、索引,从而需要更多的内部操作。
应用推荐