If table index shafts are loose, tighten mounting bolts.
如果台面索引轴松动,拧紧固定螺栓。
A reasonable structure of table index could accelerate data search speed.
合理构造表索引将有效提高数据库查询速度。
To get the best performance out of your queries it is often necessary to tailor the table index definitions.
为得到最好的查询性能,通常你需要调整表的索引定义。
Table index. Last addressed line of a standard table or sorted table. Is set to 0 if hashed table is accessed.
表索引。标准表或者排序表的最后被定位的行(表循环中当前所在行)。如果访问哈希表,则设置为0。
Information about the table space and index node groups or partitions.
关于表空间和索引节点组或分区的信息。
It is also profitable to separate index data from table data.
将索引数据从表数据中分离出来也是有益的。
Index your table columns appropriately.
适当地为表列建立索引。
The script creates a report that provides details about table and index usage.
该脚本创建一个包含关于表和索引使用的细节的报告。
Add an index to the target table.
向目标表中添加一个索引就可以了。
Inconsistent statistics may be caused when users collect the partial statistics, for example collecting table and index statistics individually, at different points in time.
用户只收集一部分数据可能会造成不一致的统计数据,例如,在不同时间分别收集表和索引统计数据。
A: Global indexes allow the flexibility of specifying a table space for each index.
A:全局索引允许灵活地为每个索引指定一个表空间。
If you expect an index to have a high cluster factor, just reorganize the table on that index.
如果您期望一个索引具有较高的群集因子,就只要重组该索引上的表。
Q: How do I calculate the table and index size for a partitioned table (or any table for that matter)?
Q:如何计算已分区表(或者任何相关的表)的表大小和索引大小?
You should create an index in a separate table space so that if something goes wrong with the index table space, you can easily drop it and then recreate the same indexes.
您应该在单独的一个表空间上创建索引,这样如果索引表空间出现问题,您可以直接删除该表空间,然后重要创建相同的索引。
Automatic table and index reorganisation.
自动表和索引重组。
Make sure that the attachment table has an appropriate index.
确定附件表格拥有一个适当的索引。
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.
优化器的操作基于数据表中的行数、数据表或索引使用的空间以及其他信息的相关统计数据。
The index exploited for the inner table happens to be a clustered index.
利用内部表的索引恰好是一个聚集索引。
These counters are incremented by the respective DML operation occurring on the partition, both table and index partitions.
这些计数器由表和索引分区中发生的各个DML操作实现值累加。
They can reduce concurrency and availability when executed against a live table or index space.
当根据活动表或索引空间执行时,会降低并发性和可用性。
Otherwise, its data or keys will be scattered throughout the extents that have been occupied by the table or index.
否则,其数据或键将分散在该表或索引所占用的所有区段中。
"Extensive" in this case may mean that 10 to 20 percent of the table and index data has been affected.
此处的“大量”可能意味着10%到20%的表和索引数据都受到了影响。
This section will deal with conversion issues that come up with DDL statements, like table and index creation statements.
本节讨论ddl语句(比如表和索引创建语句)面对的转换问题。
Since an index makes it more expensive to write to a table, create the index immediately after the bills table gets populated.
由于索引增加了写入表的成本,所以要在填充完账单表后立即创建索引。
In addition to the RUNSTATS, you can automate database backups and REORGs (defragmentation of table and index data).
除了RUNSTATS外,还可以将数据库备份和REORG(表和索引数据整理)自动化。
Because the NPSI is a single ordered list, it is easy to see how DB2 could just toggle back and forth, index to table, index to table, and return rows in ZIPCODE order without sorting.
因为NPSI是一个单序列列表,很容易看到DB 2如何来回切换,从表到索引、索引到表,然后以ZIPCODE次序返回行,而不需要排序。
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使用缓冲池来缓存它们。
Listing 11. Table and index metrics as shown by the db2pd utility.
清单11.db 2 pd实用程序显示的索引度量指标。
Example: Create a partitioned table and a partitioned index.
示例:创建已分区表和已分区索引。
应用推荐