It is recommended to create an index on the STAFF table using the DEPT and SALARY columns.
它建议使用DEPT和SALARY列在staff表上创建一个索引。
Figure 12 confirms that the new index on the STAFF table is being used in the query access plan.
图12确认查询的访问计划中使用了staff表上的新索引。
Suppose we were to create a new table, NEWSTAFF, using the table definition for the STAFF table.
假设我们要使用STAFF表的表定义来创建一个新表NEWSTAFF。
The STAFF table has grown to over a million records, and the query is therefore taking longer than it took in the past.
staff表已经增长到一百万条记录以上,因此这个查询花费的时间比以前长了。
(if your STAFF table was created with a qualifier other than db2admin, you must change it or the table will not be found.)
(如果在创建staff表时所用的限定符不是db2admin,您必须更改它,否则向导将无法找到staff表。)
We will use the DB2 Design Advisor and ask DB2 for an appropriate new index on the ORG or STAFF table to improve the performance of this query.
我们将使用DB 2Design Advisor,让DB 2在ORG或staff表上创建适当的新索引,从而改进这个查询的性能。
We will use the DB2 Design Advisor and ask DB2 for an appropriate new index on the ORG or STAFF table to improve the performance of this query.
我们将使用DB 2Design Advisor,让DB 2在ORG或staff表上创建适当的新索引,从而改进这个查询的性能。
应用推荐