This type of table space allows for best performance, but some administration is required.
这种类型的表空间可以提供最佳性能,但是需要进行一些管理。
The first approach would be to have one data element table for each type of data elements.
第一种方法是为每一种类型的数据元素准备一个数据元素表。
Table 1 shows the actual files corresponding to the type of the application archive.
表1显示了与应用程序存档类型相对应的实际文件。
Performance is negatively impacted when the table is large or when many sessions issue this type of query.
当表非常大或者大量会话发出这种类型的查询时,性能将会有所下降。
Each table space contains one or more tables based on the type of table space.
根据表空间的类型,每个表空间包含一个或多个表。
In most cases only fields from one table are selected, and a structure of the database table structure type can be used as a target structure.
在大多数情况下,只从一个表选择字段,可以使用数据库表结构类型的结构作为目标结构。
SHIPPED item information (SHIPPEDORDER) : This table contains shipping ID, Customer ID, type of box ordered, number ordered, and date ordered.
发货信息(SHIPPEDORDER):这个表包含发货id、客户ID、订购的箱子类型、订购的数量和订购的日期。
Table 1 consists of field name, field data type and comments.
表1包括字段名称、字段数据类型和注释。
The maximum size of such LDS VSAM datasets would depend indirectly upon the type of table space you create and the parameters you specify on the create statement.
这种LDSVSAM数据集的最大尺寸将间接取决于您创建的表空间的类型和您在create语句上指定的参数。
You can sort the rows within a table of data according to the data type, allowing you to order by figures - alphabetically and by date.
您还可以根据数据类型对数据表格中的行进行排序,这样便可以按数字、字母和日期进行排序。
The alternative to shredding is to store and index the MIML data in a column of type XML in a DB2 table.
作为分解方法的另一种备选方法是将MIML数据存储在db2表中的xml类型的列中,并为之建立索引。
All rows in a table are entities of a certain entity type that is represented by that table.
表中的所有列都是具有那个表所表示的某种实体类型的实体。
A structured data type can be used as the type for a column in a regular table (Listings 1 and 2), the type for an entire table (or view), or as an attribute of another structured type (Listing 3).
结构化数据类型可以用作普通表中某一列的类型(清单1和清单2),也可以用作整个表(或视图)的类型,或者用作另一个结构化类型的属性(清单3)。
DB2 LUW also stores table data on files, directories and raw devices depending upon the type of table space.
DB 2LUW还会根据表空间的类型将表数据存储到文件、目录和原始设备上。
A hard type implies that there is an associated database table and set of services for managing that type.
硬类型表示可以使用一个相关的数据库表和服务集合管理该类型。
The table that is returned can contain columns of any SQL data type, including XML.
返回的表可以包含任何SQL数据类型的列,包括XML。
The granularity of the content type is to the table level rather than the row level.
内容类型的粒度是表级别的而不是行级别的。
The ideal situation for base table row storage of XML data is when the table has only one column of XML type and the maximum size of the XML document doesn't exceed the page size.
使用XML数据基础表行存储的理想情形是,当表只有一个xml类型列并且XML文档的最大值没有超过页面大小时。
The table compares the proportion of people from each household type living in poverty in Australia in the year of 1999.
这个表格对比了1999年澳大利亚不同类型贫困家庭的人口比例。
However, instead of forcing the user to type the literal name of the database table, it would be easier to select one of the existing tables.
不过,选择一个现有表会更容易一些,这样就不必要求用户逐字输入数据库表的名称。
The number of rows produced in this table is independent from the output type.
该表中所生成的行的数量与输出类型无关。
Automated storage is not really a separate type of table space but a different way of handling DMS storage.
自动存储实际上并不是一种表空间,而是另一种处理DMS存储的方法。
Characteristics (table space type, page size, extent size) of the table Spaces used by the source and target tables must match.
源表和目标表使用的表空间的特征(表空间类型、页面大小、范围大小)必须匹配。
The administrator can choose the type of a table space as well as the containers that make up the table space.
管理员可以选择表空间的类型和组成表空间的容器的类型。
The XML data is stored in a DB2 9.1 table that contains a single column of type XML.
XML数据存储在DB2 9.1表中,其中包含单个 XML类型的列。
You'll see a table of {Target, Type, Value} triples that determine what elements in the message get set and to what value.
您将看到一个三元素表 {Target,Type,Value},该表确定了消息中设置了哪些元素以及这些元素的值。
For example even though at design time a variable of data type double can be mapped to a table column of type XML, the run time consequences are unpredictable and hence resulting in errors.
例如,虽然在运行时可以将double类型的变量映射到xml类型的表列,但是这可能导致不可预测的运行时结果,并因此而产生错误。
An XISCAN plan if only a single index is defined on the table and it is of type XML.
一个XISCAN计划,前提是只对表定义了一个单一的索引并且其类型为XML。
A table can have at most one column of type IDSSECURITYLABEL.
一个表最多只能有1个idssecuritylabel类型的列。
A table can have at most one column of type IDSSECURITYLABEL.
一个表最多只能有1个idssecuritylabel类型的列。
应用推荐