Q: Why can't I specify a table space for my local index using the CREATE index statement?
Q:为什么我无法利用CREATE index语句为我的本地索引指定表空间?
Tree index model is to create index in the memory, as the main entrance of the retrieval.
树索引亡储模式从要非树立外亡索引,做为检索的最从要的入口。
This is because the history table is usually quite large, and ClearQuest does not create index for most of the fields.
这是因为历史表格通常都是非常大的,而ClearQuest并不会为大多数的字段创建索引。
However, if you issue multiple "create index" statements, all documents in the XML column will be traversed multiple times.
然而,如果发出多条“create index”语句,那么xml列中的所有文档将被访问多次。
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等其它操作则允许表上的游标。
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语句,以便在需要时轻松地重新创建它。
Now, when creating partitioned tables, the partition boundaries are determined by the CREATE table statement instead of CREATE INDEX.
这时,当创建分区的表时,分区的边界由CREATEtable语句决定,而不是由CREATE index语句决定。
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参数的值如何。
Extensions to the create index statement enable administrators to create full text indexes to help improve the performance of such searches.
对CREATE index语句的扩展使管理员能够创建全文索引,从而帮助改进这种搜索的性能。
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根据CREATE index语句的part子句将数据划分到几个分区上。
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语句。
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 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命令定义文本索引属性,比如更新频率、文档格式、索引目录等等,从而建立文本索引基础设施。
This script will prompt you to either delete the existing index or create a new index.
这个脚本将会提示您要么删除现存的索引,要么创建一个新的索引。
The script will prompt you to either drop an existing index or create a new one.
这个脚本将会提示您要么删除现存的索引要么创建一个新的索引。
If you define uniqueness on multiple attributes within a class, create one index that includes all the attributes.
如果在一个类中的多个属性上定义惟一性,那么应该创建一个包含所有这些属性的索引。
Together with the UCLA Anderson School of Management, it has used these data to create an index to gauge what is happening to shipments of goods by road in America.
同加州大学洛杉矶分校安德森管理学院一起,它利用这些数据来创建一个指数来衡量在美国的道路货物运输。
To satisfy this query, you must compute the geographical city center, so create a functional index that computes this value.
要满足这个查询,必须计算地理城市中心,因此,需要创建一个函数索引来计算这个值。
The script will prompt you to either drop an existing multiline text index or to create a new multiline text index.
这个脚本将提示您要么删除一个现存的多行文本索引要么创建一个新的多行文本索引。
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.
您应该在单独的一个表空间上创建索引,这样如果索引表空间出现问题,您可以直接删除该表空间,然后重要创建相同的索引。
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.
如果使用这种语法在其他用户正访问的表上创建索引,那么只有当没有用户更新该表时,创建的索引才能使用。
This class can create a new index or open an existing index and add documents to it.
这个类能创建一个新的索引或者打开一个已存在的索引并为该所引添加文档。
If you need to create an index on an already existing (and populated) table, use the DEFER clause.
如果需要在一个已有的(并且被填充的)表上创建一个索引,那么可以使用defer子句。
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子句在用户数据所在的表空间上创建一个索引,或者在其他表空间上创建索引。
Much of the work required to create a searchable index can be performed from the command line.
创建可搜索索引所需的大部分工作可以通过命令行执行。
Deciding which index to create is a significant burden for GAE developers.
决定要创建哪个索引对于GAE开发人员来说是一个很大的负担。
Then you create the index if it doesn't exist and add the item to it.
然后创建这个索引(如果尚未存在的话)并把条目添加到其中。
Testing out an index on a workload without having to create the index.
测试工作负载上的索引而无需创建该索引。
Since an index makes it more expensive to write to a table, create the index immediately after the bills table gets populated.
由于索引增加了写入表的成本,所以要在填充完账单表后立即创建索引。
To reduce contention, DROP and re-CREATE the index using the RANDOM option.
为了减少争用,DROP并使用RANDOM选项重新CREATE索引。
应用推荐