When you do add an index to a table to cut the CPU cost and run time of a query, you want to get the most out of that new index as practically possible.
如果您的确要向一个表添加一个索引来削减查询的CPU成本和运行时间，您可能会想在实际情况允许的条件下尽可能多地利用那个新索引。
The "DbTable query Wizard" dialog opens to help you construct your query, after which the table is updated with the new data.
“数据表查询向导”对话框可以帮助你构造你自己的查询语句，之后数据表会被新数据更新。
Define a new query for this bean, being sure to specify the values listed Table 1.
为这个程序定义一个新的问题查询，确保能够具体指定表格1中所列出的值。
You execute an SQL query against your table with MYSQL_QUERY() and with the result, you reformat using WHILE to walk through the resulting object, and reformat the data into a new simple array.
您使用 MYSQL_QUERY()对您的表执行SQL查询，然后您使用WHILE 重新格式化结果来预排将得到的对象，并将数据重新格式化为新的简单阵列。
Figure 12 confirms that the new index on the STAFF table is being used in the query access plan.
图12确认查询的访问计划中使用了staff表上的新索引。
To create a new feed from the product table, the production manager first clicks on the New Feed link on the main page and selects Relation Database Query (SQL) from the supported data sources list.
为了从产品表创建新的提要，生产经理首先单击主页上的NewFeed链接，并从受支持数据源列表中选择 RelationDatabaseQuery (SQL)。
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表上创建适当的新索引，从而改进这个查询的性能。
Another way to provide a new and better access path for a query is through the use of DB2's materialized query table (MQT) functionality.
为查询提供更好的访问路径的另一种方法是使用DB2的物化查询表(MQT)功能。
Describes how to create a query that creates a new table.
描述如何创建创建新表的查询。
You can copy rows into a new table using a Make table query, which is useful for creating subsets of data to work with or copying the contents of a table from one database to another.
可使用“生成表”查询将行复制到一个新表中，“生成表”查询对创建要使用的数据子集或在数据库之间复制表的内容非常有用。
Users can use the table to add new revenue and expenditure balance type, delete unwanted or vague categories, and can query and browsing information system in all categories.
用户可以用收支分类表自行添加新的收支类型，删除不需要的或模糊的类目，并可查询和浏览系统中所有类目信息。收支类型信息作为系统信息为各种记账活动提供选择。
Users can use the table to add new revenue and expenditure balance type, delete unwanted or vague categories, and can query and browsing information system in all categories.
用户可以用收支分类表自行添加新的收支类型，删除不需要的或模糊的类目，并可查询和浏览系统中所有类目信息。收支类型信息作为系统信息为各种记账活动提供选择。
应用推荐