StreamAggregate and ComputeScalar occur when an aggregate function (MIN, MAX, COUNT, AVG, or SUM) is used in an aggregate query. SELECTCOUNT (*), AVG (Value) fromm2c_10 min and MAX functions require stream aggregation. Other functions in the execution plan require stream aggregation followed by one or more scalar calculation operations. -12. Execution of stream aggregation and scalar computing
Aggregation
Stream Aggregate and Compute Scalar occur when an Aggregate function (MIN, MAX, COUNT, AVG, or SUM) is used in a query.
Select count (*), AVG (Value) FROM M2C_10
The MIN and MAX functions require stream aggregation. Other functions in the execution plan require stream aggregation followed by one or more scalar calculation operations.
-12.Execution Plan of stream aggregation and scalar computing
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.