The index partition for each data partition can be in a different table space.
每个数据分区的索引分区可以位于不同的表空间中。
It is also profitable to separate index data from table data.
将索引数据从表数据中分离出来也是有益的。
Q: Can the local index partition and data partition be in the same table space for each partition?
Q：每个分区的本地索引分区和数据分区能否处于同一表空间中？
Index scans are usually the most efficient way to access data, especially when the table is large but the number of qualified rows is small.
一般来说，索引扫描是访问数据的最有效的方法，尤其是表很大但符合条件的行很少的时候。
An index only scan is an index access that is not followed by a table access because the index itself contains all the requested data.
仅扫描索引是未包含表访问的索引访问，因为索引本身包含了所有被请求的数据。
From the table space snapshot data, the used page objects can be used to tell the total size of the index, tables, and the total database size.
从表空间快照数据中可以看出，这些用过的页面对象可用于告知索引、表和数据库的总大小。
This means that you should either load your data prior to creating your index or update the statistics on your table after your data is loaded.
这意味着您应该在创建索引之前加载数据，或者在加载数据之后更新表的统计信息。
You can use the in clause to create an index in the same table space where user data resides, or in a different table space.
您可以使用in子句在用户数据所在的表空间上创建一个索引，或者在其他表空间上创建索引。
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类型的列中，并为之建立索引。
Other table spaces for user, temporary and index data need to be created after the database has been created, and a user needs to be assigned to these table spaces before they can be used.
其他用于用户数据、临时数据和索引数据的表空间则需要在创建数据库之后另行创建，并且在使用这些表空间之前，还需要为之指定一个用户。
PCTFREE indicates to DB2 what percentage of each page in the table space or index to leave free when either loading or reorganizing the data.
PCTFREE 告诉DB2在装载或重组数据时，表空间或索引中的每个页要留出多少百分比的空余空间。
To check integrity of table data, you can index keys to table rows, and table rows to associated LOBs.
要检查表数据的完整性，您可以在表的数据行设置索引键，并将表的数据行关联到相关的LOB。
The optimizer ACTS based on statistical data about the number of rows in a table, the use of space by a table or index, and other information.
优化器的操作基于数据表中的行数、数据表或索引使用的空间以及其他信息的相关统计数据。
For each table you want to register, there will be a change data (CD) table and CD index created.
对于您想要注册的每个表，都会创建一个更改数据(CD)表和CD索引。
If multiple indexes are defined on the table, the optimizer USES the index that can rule out the most data in the table.
如果表上定义了多个索引，那么优化器就使用可以排除表中最多数据的索引。
If you don't specify an index or long table space, partitioned indexes and long column data will go in the same table space as the data.
如果不为索引或长列指定表空间，分区索引和长列数据会存储在与数据相同的表空间中。
Otherwise, its data or keys will be scattered throughout the extents that have been occupied by the table or index.
否则，其数据或键将分散在该表或索引所占用的所有区段中。
The way to establish a certain data clustering property in DB2 is to reorganize the table according to an index.
在DB 2中建立数据聚集属性的方法是根据一个索引对表进行重组。
"Extensive" in this case may mean that 10 to 20 percent of the table and index data has been affected.
此处的“大量”可能意味着10%到20%的表和索引数据都受到了影响。
Hence, while you can specify the table space where the index object containing all the indexes for a data partition go, it is not possible to specify a table space for each individual index.
因此，在索引对象包含数据分区的全部索引的情况下，指定表空间时，就无法为每个单独的索引指定表空间。
In addition to the RUNSTATS, you can automate database backups and REORGs (defragmentation of table and index data).
除了RUNSTATS外，还可以将数据库备份和REORG(表和索引数据整理)自动化。
In this example, 10 percent of table data pages are used for the collection of table statistics, while for index statistics all of the index pages will be used.
本例中，10%的表数据页用于表统计信息的收集，而对于索引统计信息，将使用所有的索引页。
DB2 USES buffer pools to cache the table and index data as they are being read or written to the hard disk drive.
当从硬盘驱动器读写表和索引数据时，DB 2使用缓冲池来缓存它们。
When creating a partitioned table space in DB2 UDB V7, DB2 divides the data among the partitions according to the part clause of the CREATE INDEX statement.
在DB 2UDBV 7中创建分区的表空间时，DB 2根据CREATEindex语句的part子句将数据划分到几个分区上。
The MTK GUI and CLI provide more flexibility to include your own DATA, INDEX, and LONG DATA table spaces.
MTKGUI和CLI提供了更大的灵活性，使您可以包括自己的DATA、INDEX 和LONG DATA表空间。
Index creation on a table that contains data.
在包含数据的表上创建索引。
The data, index, long field, and LOB portions of a table can be stored in the same tablespace, or can be individually broken out into separate tablespaces for performance reasons.
一个表中的数据、索引、long字段和LOB部分可以存储在相同的表空间中，也可以分别放到不同的表空间中，以提高性能。
Now, to get various portions of the data, I create a stats.php page that, given a start and end index, returns an HTML table with just that portion of the data.
现在，为了获得数据的各个部分，我创建了一个stats.php页面，该页面提供了一个开始和结束索引，返回一个只包含该部分数据的HTML表格。
HSQLDB keeps all table and index data in memory, saving all SQL statements issued into a file named database.script, which also ACTS as the transaction log.
HSQLDB将所有表和索引数据放在内存中，将所有发出的sql语句保存到一个名为database .script的文件中，该文件同时也充当着事务日志的角色。
IndexTSName: Identifies the table space in which the partitioned index for each data partition is to be stored.
IndexTSName：指定存储每个数据分区的分区索引的表空间。
应用推荐