这是一件好事,所有的突然,而不是被约束至3个索引寄存器,编译器可以使用它们中的6个。
This was a good thing, all of a sudden, instead of being constrained to 3 index registers, the compiler could use 6 of them.
对于一个现存约束,要禁用索引支持没有别的选择。
There is no option to disable index support for an existing constraint.
以其他方式修改数据库,包括添加、删除或修改索引或其他约束。
Changing the database in other ways, including adding, dropping, or modifying indexes or other constraints.
我所能获取的列太多,又很容易遗漏重要的结构化数据库特性,比如索引或空约束。
I can fetch too many columns, or leave off important structural database features, like indexes or null constraints.
当定义一个主键约束时,联邦系统自动创建一个惟一的索引规范。
When a primary key constraint is defined, the federated system automatically creates a unique index specification.
昵称可以包含列、统计信息、索引或信息约束。
Nicknames can have columns, statistics, indexes, or information constraints.
索引键大小限制也应用于通过索引施加的那些约束。
The index key size limit also applies to those constraints that are enforced through indexes.
前面已经讨论过,这种处理可能以不同的形式出现,例如索引维护、约束验证或者触发器执行。
As discussed earlier, this processing could take such forms as index maintenance, constraint verification, or trigger execution.
目前的CTP 1仅支持表、索引和约束。
这两个数据库系统都支持主键,以及支持加速查询和约束输入的键索引。
The two database systems support primary keys, along with key indices that allow you to speed up queries and constrain input.
用于为外键约束禁用索引的新语句被使用alter语句添加来使用。
New syntax for disabling an index for foreign key constraint was added to use with the ALTER statement.
每种设计器允许创建索引、约束、键和触发器(如适用)。
Each designer allows creating indexes, constraints, keys, and triggers (where applicable).
索引扫描实际上是对父表进行主键查找,并完成外键约束验证。
The latter is actually a primary key lookup against the parent table and constitutes the foreign key constraint verification.
当约束创建完成后,禁用支持约束的索引,空间被释放。
When the constraint creation is complete, the index supporting the constraint is disabled and its space is dropped.
创建一个索引禁用的外键约束。
将insert期间出现约束、索引和触发器的机会降至最少。
Minimize the presence of constraints, indexes, and triggers during the inserts.
定位并修复数据库在约束、触发器、区(extent)和索引上的问题,同时可以让Toad直接利用OracleOCI调用获得对OracleAPI的完全访问。
Find and fix database problems with constraints, triggers, extents, indexes, and grants Toad utilizes direct Oracle OCI calls for full access to the Oracle API.
注意,如果物理文件使用了键控(可能因为它有一个PrimaryKey约束),其隐式索引也将通过这些命令被移动到SSD或从中移出。
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.
还可以创建表、视图、用户、约束与索引。
It can also be used to create tables, views, users, constraints and indexes.
成功地由版本11.50 .xC 7升级到11.70 .xC1之后,您可以使用以下命令,创建一个索引禁用的外键约束。
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.
这包括DDS创建的文件和SQL索引,以及带有PrimaryKey约束的物理文件。
This includes both DDS-created files and SQL indexes as well as physical files with a Primary Key constraint.
ccd表中必须有惟一性约束——可以通过主键或者源表或ccd表上的惟一索引实现。
Uniqueness in the CCD table must be enforced — either by a primary key or unique index on the source table or CCD table.
要终止索引禁用的外键约束,重新创建这个参考约束,执行以下命令
To drop the foreign key constraint with index disabled and recreate this referential constraint, issue the following command
注意编写7个不等式作为5个不必有序的决策变量的和太过繁琐了,因为在某些约束中,索引可能会覆盖索引值7。
Note that it would be too boring to write seven inequalities as a sum of five decision variables that are not necessarily in order, because in some constraints, the index may overlap the index 7.
然而。不管rdbms支持文本索引和搜索功能如何优秀,该活动仍然受特定rdbms自身的数据范围的约束。
However, no matter how well an RDBMS supports text indexing and searching, that activity is still constrained to the scope of the data within the particular RDBMS itself.
您有一个索引与Unique或ForeignKey约束关联并且该索引被大量的查询所使用,您希望将这个索引放入SSD。
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.
指定为约束创建的索引的存储位置。
Specifies the storage location of the index created for the constraint.
可以传输表、数据、存储过程、引用完整性约束、安全性和索引。请指定要传输的对象。
Transfer tables, data, stored procedures, referential integrity constraints, security, and indexes. Specify the object (s) to transfer.
在多数情况下,列上的约束,索引,和统计信息也被移除。
In most cases, constraints, indexes, and statistics defined on the column are also removed.
表必须具有相同的主键、唯一索引或唯一约束。
Tables must have the same primary key, unique index, or unique constraint.
应用推荐