There is no option to disable index support for an existing constraint.
对于一个现存约束,要禁用索引支持没有别的选择。
When a primary key constraint is defined, the federated system automatically creates a unique index specification.
当定义一个主键约束时,联邦系统自动创建一个惟一的索引规范。
As discussed earlier, this processing could take such forms as index maintenance, constraint verification, or trigger execution.
前面已经讨论过,这种处理可能以不同的形式出现,例如索引维护、约束验证或者触发器执行。
When the constraint creation is complete, the index supporting the constraint is disabled and its space is dropped.
当约束创建完成后,禁用支持约束的索引,空间被释放。
Creating a foreign key constraint with index disabled.
创建一个索引禁用的外键约束。
Note that if the physical file is keyed (perhaps because it has a Primary key constraint), its index will also be moved on or off of SSD with these commands.
注意,如果物理文件使用了键控(可能因为它有一个PrimaryKey约束),其隐式索引也将通过这些命令被移动到SSD或从中移出。
After converting successfully from version 11.50.xc7 to 11.70.xc1, you can use the following commands to create a foreign key constraint with index disabled.
成功地由版本11.50 .xC 7升级到11.70 .xC1之后,您可以使用以下命令,创建一个索引禁用的外键约束。
After the foreign key constraint with index disabled is dropped and recreated, the reversion completes successfully.
终止和重新创建索引禁用的外键之后,降级就成功完成了。
New syntax for disabling an index for foreign key constraint was added to use with the ALTER statement.
用于为外键约束禁用索引的新语句被使用alter语句添加来使用。
To drop the foreign key constraint with index disabled and recreate this referential constraint, issue the following command
要终止索引禁用的外键约束,重新创建这个参考约束,执行以下命令
You have an index that is associated with a Unique or Foreign Key constraint that is heavily used in queries that you want to put on SSD.
您有一个索引与Unique或ForeignKey约束关联并且该索引被大量的查询所使用,您希望将这个索引放入SSD。
Specifies the storage location of the index created for the constraint.
指定为约束创建的索引的存储位置。
Tables must have the same primary key, unique index, or unique constraint.
表必须具有相同的主键、唯一索引或唯一约束。
The spatiotemporal index for the constraint network is one of the key issues in this field.
受限网络中的时空索引是解决此类时空数据管理问题的关键所在。
A UNIQUE index creates a constraint such that all values in the index must be distinct.
UNIQUE索引创建一个约束,使得索引中的所有值必须是不同的。
Epipolar constraint was applied to limit candidate-matching point to a line distribution and coding structured light was used to tell the grating index.
外极线约束将可能的候选点限制在直线分布,引入编码光用来确定光栅条纹的级次。
Incentive and Constraint Mechanism of project managers is based on the scientific appraisal index system.
要在完善项目经理绩效考评体系的基础上,完善项目经理的激励约束机制。
Incentive and Constraint Mechanism of project managers is based on the scientific appraisal index system.
要在完善项目经理绩效考评体系的基础上,完善项目经理的激励约束机制。
应用推荐