Describes each data element within the bulk data store, such as source organization, application support, data summary, index, catalog, or digests.
描述批量数据存储中的每个数据元素,例如源组织、应用程序支持、数据汇总、索引、目录或摘要。
An entry is added to the system catalog to indicate to the query optimizer that such a remote index exists.
一个条目被添加到系统编目中,以向查询优化器表明存在那样的一个远程索引。
If the catalog statistics are up to date and DB2 knows that a particular index is poorly organized, DB2 may decide not to use it.
如果编目统计数据是最新的,而DB 2知道某个索引组织得不好,DB 2就可能决定不使用它。
Example 27. Collect detailed catalog statistics on both indexes, but use sampling instead of performing detailed calculations for each index entry.
收集两个索引上的详细目录统计信息,但对每个索引条目使用抽样来代替执行详细的计算。
Example 37. To collect extended index catalog statistics.
收集扩展的索引目录统计信息。
Example 13: Collect catalog statistics with distribution on all columns that are part of the index, plus two columns that are not.
示例13:收集构成索引的所有列以及两个非索引列中包含分布的目录统计信息。
System catalog changes: a FOT index creates a new entry in the existing sysindices table.
系统目录变更:FOT索引创建了当前sysindices表格中一个新输入。
Update the catalog statistics with the runstats command so that the optimizer can take this newly created index into account.
用runstats命令更新目录统计数据,以便优化器可以考虑这个新创建的索引。
Example 38. To collect extended index catalog statistics specifying that sampling should be used.
收集扩展的索引目录统计信息,指定使用抽样。
The foreign key index will be disabled, and the sysobjstate catalog table will reflect that state.
外键索引将被禁用,sysobjstate目录表格也会反映该状态。
Using this table function instead of db2pd simplifies evaluation of the results because the index IDs (IIDs) can be converted to index names by joining with the SYSCAT.INDEXES catalog view.
使用表函数取代 db2pd实用程序简化了结果计算,因为可以通过与 SYSCAT.INDEXES 目录视图结合将索引IDs (IIDs)转换成索引名。
To get the name of the index with ID 3, query the SYSCAT.INDEXES catalog view using a SELECT statement, as shown in Listing 12.
要获得ID3索引的名称,请使用SELECT语句查询 SYSCAT.INDEXES目录视图,如清单 12 所示。
In the meantime, the Library of Congress won't be creating a catalog of all these tweets and all this data, but they do want to be able to index the material so researchers can effectively search it.
与此同时,国会图书馆不会给所有这些推讯和数据编制目录,但是他们的确希望能够给这些资料建立索引,以便研究人员有效地搜索。
Collecting catalog statistics can also be issued during a LOAD REPLACE of a table, as well as during the creation of an index.
在表的LOADREPLACE期间以及索引的创建期间,也可以进行目录统计信息的收集。
After you gather a list of citations from a periodical index, check to see if your library owns that magazine or journal by searching for the title of the periodical in the library catalog.
当你从期刊索引上收集了一系列的引用时,从图书馆目录上通过搜索期刊刊名检查你的图书馆是否拥有该杂志或期刊。
Listing 8 shows an index for the source catalog.
清单8显示了数据源catalog的索引。
The full-text index exceeds the limit for the number of rows that can be contained in a full-text catalog.
全文索引超过了全文目录中可以包含的行数限制。
This action forces the server to re-create the search index catalog.
此操作将强制服务器重新创建搜索索引编录。
Inflation as measured by the consumer price index reflects the annual percentage change... Catalog Sources World Development Indicators.
通胀(居民消费价钱指数权衡的)年度百分比变化……目录来源“世界开展指标”。
One full-text catalog can have several full-text indexes, but a full-text index can only be part of one full-text catalog.
一个全文目录可以包含多个全文索引,但一个全文索引只能用于构成一个全文目录。
Oracle9i adds Internet search, powerful facilities to extract and index metadata from rich content, and the ability to search XML and catalog structures.
Oracle9i增加了互联网查找,从丰富内容中抽取和索引元数据的强大工具,以及查找XML数据和编目结构化数据的能力。
Oracle9i adds Internet search, powerful facilities to extract and index metadata from rich content, and the ability to search XML and catalog structures.
Oracle9i增加了互联网查找,从丰富内容中抽取和索引元数据的强大工具,以及查找XML数据和编目结构化数据的能力。
应用推荐