To better illustrate the improvement in cardinality estimation, drop all the existing indexes on the EMPLOYEE table except the primary key index.
为了更好地解释说明基数估计值的提高,撤销除主键索引外的所有employee表上的现有索引。
It queries your database, indexes each column in each row of the result, and ties each index entry to the row's primary key.
它将查询数据库,为结果的每行中的每列建立索引,并且将每个索引条目绑定到行的主键上。
Also, before setting up replication in DB2, you will want to ensure that every database table has a primary key or unique index.
此外,在DB 2中创建复制之前,您会希望保证每一个数据库表都具有一个主键或惟一索引。
When a primary key constraint is defined, the federated system automatically creates a unique index specification.
当定义一个主键约束时,联邦系统自动创建一个惟一的索引规范。
We keep only a compound primary key and a secondary index for each row, and answer all queries from a single index.
我们只保留了一个组合主键和一个辅助索引来完成所有的查询。
The primary key and any unique index of the table must be a superset of the associated partitioning key.
表的主键和所有惟一索引都必须是相关分区键的超集。
The reason for this is that the other tables in the DB2 UDB SAMPLE database have no primary key, and hence no index information to associate a unique ECO key with.
原因是DB2UDBSAMPLE数据库中的其他表没有主键,因此没有索引信息可以关联惟一的ECO 键。
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.
注意,如果物理文件使用了键控(可能因为它有一个Primary Key约束),其隐式索引也将通过这些命令被移动到SSD或从中移出。
Uniqueness in the CCD table must be enforced — either by a primary key or unique index on the source table or CCD table.
ccd表中必须有惟一性约束——可以通过主键或者源表或ccd表上的惟一索引实现。
The sql_query must include the primary key you want to use for subsequent lookups, and it must include all the fields you want to index and use as groups.
sql _ query必须包括后续查找需要使用的主键,并且它必须包括需要索引和用作组的所有字段。
In other words, all columns that are part of the partitioning key must be present in the primary key or unique index definition.
换句话说,作为分区键一部分的所有列都必须出现在主键或惟一索引定义中。
This index requires each value in the primary key to be unique.
该索引要求主键的每一个值都必须是唯一的。
Use the Index or primary key field to select the key columns that the Q Apply program uses to identify replicated rows and correctly order transactions.
使用Indexorprimary key字段来选择键列,QApply程序用以识别复制的行以及正确命令事务。
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代码生成系统恰当地生成用于定义主键的CREATEINDEX语句。
The new table 'test'. '_online_table_new' does not have a PRIMARY KEY or a unique index which is required for the DELETE trigger.
原表需要一个主键或则唯一索引,因为删除的触发器需要,否则数据不会被复制。
Porosity, a key index of porous materials, is the most primary factor for many properties of porous materials.
孔率是多孔材料的关键指标,是多孔材料若干性能最主要的决定性因素。
Tables must have the same primary key, unique index, or unique constraint.
表必须具有相同的主键、唯一索引或唯一约束。
Why do we usually create an index before dropping the primary key?
为什么我们通常在删除主键创建索引?
Modify a primary key if you want to change the column order, index name, clustered option, or fill factor.
如果要更改列顺序、索引名称、聚集选项或填充因子,则要修改主键。
If the source table doesn't include a primary key or clustered index, the tool can automatically add a ROWID column and set the clustered index on the column during the conversion.
如果源表不包含主键或聚簇的索引,该工具可以自动添加rowid列和列上的聚集的索引设置转换过程中。
Recommendations to optimize the time, together with the primary key and index, query efficiency will improve.
建议优化的时候,加上主键和索引,查询效率会提高。
Recommendations to optimize the time, together with the primary key and index, query efficiency will improve.
建议优化的时候,加上主键和索引,查询效率会提高。
应用推荐