Memory constraint is one of the key reasons for under-utilized processing power.
内存约束是处理能力利用率低下的主要原因之一。
But from our data model's perspective, there is no unique table we can use to create our foreign key constraint, like the one between TB_RIGHT and TB_PERSON.
但是从我们数据模型的角度来看,我们没有一个惟一的表可以用来创建我们的外键约束,就像TB_RIGHT和TB_PERSON之间那样。
When a primary key constraint is defined, the federated system automatically creates a unique index specification.
当定义一个主键约束时,联邦系统自动创建一个惟一的索引规范。
As shown in Figure 16, the bulk load operation results in two of the sample records being sent to the reject link because they violate the unique primary key constraint.
如图16所示,两个示例记录中的批量加载操作结果被发送给拒绝链接,因为它们违反唯一的主键约束。
This clause is not allowed if the column is specified in the primary key, or in a unique constraint of the table (SQLSTATE 42831).
如果表的主键或惟一性约束中指定了这个列,那么不允许使用这个子句(SQLSTATE 42831)。
This category of overhead includes CHECK constraint verification and foreign key constraint (referential integrity (ri)) verification.
这一类的开销包括检查约束验证和外键约束(参照完整性(RI))验证。
To enforce that specified keys are unique with respect to the specific time period, specify the primary key constraint BUSINESS_TIME WITHOUT OVERLAPS as the last item with the list of other keys.
要确保指定的键在特定时间段内是惟一的,可以指定主键约束BUSINESS_TIMEWITHOUTOVERLAPS作为包含其他键的列表中的最后一项。
New syntax for disabling an index for foreign key constraint was added to use with the ALTER statement.
用于为外键约束禁用索引的新语句被使用alter语句添加来使用。
The latter is actually a primary key lookup against the parent table and constitutes the foreign key constraint verification.
索引扫描实际上是对父表进行主键查找,并完成外键约束验证。
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。
This includes both DDS-created files and SQL indexes as well as physical files with a Primary Key constraint.
这包括DDS创建的文件和SQL索引,以及带有PrimaryKey约束的物理文件。
Creating a foreign key constraint with index disabled.
创建一个索引禁用的外键约束。
Next, select the newly added foreign key constraint in the editor and specify the key columns using the Properties view.
接下来,在编辑器中选择新添加的外键约束,并使用Properties视图指定关键列。
The Message Key is used for display purposes when the constraint fails.
MessageKey用来显示约束失败的情况。
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之后,您可以使用以下命令,创建一个索引禁用的外键约束。
In table 6, the INSERT into the Orders table fails due to a foreign key constraint violation on custno.
在表6中,对orders表执行insert语句失败,因为custno违背了外键约束。
To drop the foreign key constraint with index disabled and recreate this referential constraint, issue the following command
要终止索引禁用的外键约束,重新创建这个参考约束,执行以下命令
Syscat.tabconst Contains a row for each unique (u), primary key (p), foreign key (f), or table check (k) constraint db2 select constname, tabname, type from syscat.tabconst.
tabconst为每个唯一性(U)、主键(p)、外键(f)或者表检查(K)约束保持一个行db2select constname,tabname,typefrom syscat . tabconst。
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 the foreign key constraint with index disabled is dropped and recreated, the reversion completes successfully.
终止和重新创建索引禁用的外键之后,降级就成功完成了。
Assembly constraint is the key information for supporting the assembly operation in distributed virtual environments.
装配约束是用来支持分布式虚拟环境中装配交互操作的关键信息。
The schema constraint count(key('ids', .)) = 1 checks the set of all identifiers to be sure that only one has the current value (in other words whether the identifier is unique).
模式将限定count(key('ids',.) ) =1检查所有的标识符,从而确保只有一个包含当前值(换句话说,确定该标识符是否是惟一的)。
You cannot define a foreign key constraint in a CREATE TABLE statement that contains an AS subquery clause.
你不能在CREATETABLE语句中包含AS子查询子句定义一个外键约束。
Errors that are raised during the EXECUTE or FETCH phase of execution, such as a unique key constraint violation, can be returned in more than one way.
对于在执行期间的EXECUTE或FETCH阶段产生的错误,比如uniquekey constraint违背,可以以多种方式返回。
The referenced unique or primary key constraint on the parent table or view must already be defined.
引用唯一或主键约束,必须是父表中已经定义的。
To do so, click on the Add icon, and then select the database object type Foreign Key Constraint, as shown in Figure 4c.
为此,单击add图标,然后选择数据库对象类型ForeignKey Constraint,如图4c所示。
One of the key technique problems is boundary dynamic contact constraint and contact judgment in FEA simulation for 3d complicated massive forming.
边界界面动态接触约束与接触判断是3维复杂体积成形有限元数值模拟的关键技术问题之一。
Searching is the key step of constraint solving.
解空间搜索是约束求解的关键环节。
The key inner control links which are in division of labor, interface and constraint with each other in the operation management of the enterprise are illustrated.
列示了企业在经营管理中既相互分工负责,又互相牵制、相互制约的主要内部控制环节和容易发生问题的失控点。
Clinical Relevance the olecranon is a key osseous constraint of the elbow.
鹰嘴是肘关节一个关键的骨性限制结构。
应用推荐