Query-by-example的意思|示意

For example, you can minimize the rows read by having predicates in the query that can determine the needed rows from just the index alone.

例如，您可以通过把可以仅从索引就确定需要的行的谓词放到查询中来将行读取降到最低。

For example, you can get a count out of the database for the number of respondents who have stated that their favorite color (question 2) is red by using the following query shown in Listing 10.

例如，使用下面的清单10中的查询，您可以从数据库中查询最喜欢的颜色是红色(问题2)的回答者的数目。

If you have a long-running database query for example that's triggered by a button press, you can simply increase the time paused after the button event has been issued.

如果你有一个运行时间很长的数据库查询(比如由按钮点击所触发)，那么在按钮事件产生后你可以增加延迟时间。

However, every time the user asked for a system refresh by sorting her tasks by due date, for example, the portal application had to issue a new query to WPS to repopulate the task list.

不过，每次用户要求系统刷新（例如，按照结束日期对任务进行排序）时，门户应用程序必须向 WPS 发送新查询，以重新填充任务列表。

Start by generating the query using the first aggregation function (SUM in the example) in the measure's list of aggregations to aggregate the template expression.

先使用度量的聚合列表中的第一个聚合函数(在这个示例中是SUM)对表达式模板进行聚合，产生一个查询。

Our next example, shown in Figure 2, is a query with an ORDER BY clause using the code below.

我们的下一个例子，如图2所示，是一个含有ORDER BY子句的查询，它使用了下面的代码。