If table index shafts are loose, tighten mounting bolts.
如果台面索引轴松动,拧紧固定螺栓。
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。
You can explore all of these options on your own by right-clicking on the schema object (a table, view, index, or schema) to see which options are available for that particular object.
您可以通过在模式对象(表、视图、索引或模式)上单击右键自己探索这些选项,看看对于特定的对象有哪些可用的选项。
Now step through the rows in Table 1 to explore index eligibility for each predicate.
下面浏览一下表1中的行,来研究每个谓词的索引合格性。
The script creates a report that provides details about table and index usage.
该脚本创建一个包含关于表和索引使用的细节的报告。
Inconsistent statistics may be caused when users collect the partial statistics, for example collecting table and index statistics individually, at different points in time.
用户只收集一部分数据可能会造成不一致的统计数据,例如,在不同时间分别收集表和索引统计数据。
If you use this syntax to create an index on a table that other users are accessing, the index is not available until no user is updating the table.
如果使用这种语法在其他用户正访问的表上创建索引,那么只有当没有用户更新该表时,创建的索引才能使用。
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.
您应该在单独的一个表空间上创建索引,这样如果索引表空间出现问题,您可以直接删除该表空间,然后重要创建相同的索引。
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.
仅扫描索引是未包含表访问的索引访问,因为索引本身包含了所有被请求的数据。
Finally, an index on the additional column is created and the table reorganized based on that 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操作实现值累加。
For each table you want to register, there will be a change data (CD) table and CD index created.
对于您想要注册的每个表,都会创建一个更改数据(CD)表和CD索引。
This library has no catalogue, and none of the books has an index or table of contents.
这个图书馆没有书本目录,每本书也没有索引或内容目录。
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%的表和索引数据都受到了影响。
There is an attribute RUNSTATS TIMESTAMP on the table or index node of the access plan graph that indicates the last time when the statistics were collected.
在访问计划图的表或索引节点上会有一个RUNSTATSTIMESTAMP属性,它表示收集统计数据的时间。
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使用缓冲池来缓存它们。
The BTYPE column identifies the object type: 'T' for table, 'I' for index, and 'F' for function instance.
BTYPE列显示对象类型:'T' 表示表,'I' 表示索引,'F' 表示函数实例。
The degree of clustering of an index; that is, the extent to which the physical sequence of rows in a table follows an index.
一个索引的群集程度;即,表中行的物理顺序与索引的符合程度。
应用推荐