This is because the history table is usually quite large, and ClearQuest does not create index for most of the fields.
这是因为历史表格通常都是非常大的,而ClearQuest并不会为大多数的字段创建索引。
The load and create index operations always use private sorts for index key sorting, regardless of the value of the INTRA_PARALLEL parameter.
装入和创建索引的操作通常使用私有排序进行索引键的排序,无论INTRA_PARALLEL参数的值如何。
Q: Why can't I specify a table space for my local index using the CREATE index statement?
Q:为什么我无法利用CREATE index语句为我的本地索引指定表空间?
Extensions to the create index statement enable administrators to create full text indexes to help improve the performance of such searches.
对CREATE index语句的扩展使管理员能够创建全文索引,从而帮助改进这种搜索的性能。
Whenever possible, create all indexes on a table before initially loading it, since the load utility builds indexes more efficiently than the create index process.
只要有可能,应该在初次装载一个表之前创建其所有索引,因为LOAD实用程序建立索引的效率比CREATE INDEX过程要高。
The granularity of locking used on an index can be set using the CREATE INDEX and ALTER INDEX statements.
指定的索引名称必须与当前的现有索引相同;但可以修改索引定义。
If you do decide to drop an index, you should first save its create index statement so that you can easily recreate it if necessary.
如果您决定删除索引,那么首先要保存它的CREATE index语句,以便在需要时轻松地重新创建它。
However, if you issue multiple "create index" statements, all documents in the XML column will be traversed multiple times.
然而,如果发出多条“create index”语句,那么xml列中的所有文档将被访问多次。
The create index command establishes the text index infrastructure by defining the text index attributes, such as update frequency, a document format, an index directory, and so on.
create index命令定义文本索引属性,比如更新频率、文档格式、索引目录等等,从而建立文本索引基础设施。
Now, when creating partitioned tables, the partition boundaries are determined by the CREATE table statement instead of CREATE INDEX.
这时,当创建分区的表时,分区的边界由CREATEtable语句决定,而不是由CREATE index语句决定。
Some operations like ALTER table require no cursor to be open, while others like CREATE INDEX ONLINE allow cursors on the table.
ALTERTABLE等一些操作要求不打开游标,而CREATE INDEXONLINE等其它操作则允许表上的游标。
This particular annotation indicates to the pureQuery's DDL code generation system to properly generate the CREATE INDEX statement for defining the primary key.
这个标注指示pureQuery的DDL代码生成系统恰当地生成用于定义主键的CREATE INDEX语句。
This particular annotation indicates to the pureQuery's DDL code generation system to properly generate the CREATE INDEX statement for defining the primary key.
这个标注指示pureQuery的DDL代码生成系统恰当地生成用于定义主键的CREATE INDEX语句。
应用推荐