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中创建复制之前,您会希望保证每一个数据库表都具有一个主键或惟一索引。
应用推荐