OLAP queries typically aggregate many rows of the fact table into a relatively small number of summary results.
OLAP查询通常将事实表的许多行聚合成一个相对少量的汇总结果。
In V8, the predicate was not pushed down to CF, and nearly one million rows had to be moved to the federated server to evaluate the predicate and perform the aggregate.
在V 8中,谓词没有被下推到CF,为了计算谓词和执行聚合,需要将大约1百万个行移动到联邦服务器。
To display the number of job applications containing a skill, change the aggregate function of the ID columns by selecting the ID columns of the crosstab (select the headers, not the rows below).
要显示包含某项技能的职位申请的数量,选择cross选项卡的id列(不是选择标题,而是选择标题下方的列),修改id列的聚合函数。
F. You can not group by the rows of a table by more than one column while using aggregate functions.
在多于一个栏位的情况下不能使用聚合函数来对一个表的行进行分组。
They differ from aggregate functions in that they return multiple rows for each group.
与集合函数不同,他们返回各分组的多行记录。
When you use an aggregate function, by default the summary information includes all specified rows.
当使用聚合函数时,默认情况下,汇总信息包含所有指定的行。
When you use an aggregate function, by default the summary information includes all specified rows.
当使用聚合函数时,默认情况下,汇总信息包含所有指定的行。
应用推荐