Topic
2 replies Latest Post - ‏2012-05-07T12:26:40Z by geneK
geneK
geneK
7 Posts
ACCEPTED ANSWER

Pinned topic Does the "group by" operator push the aggregation down to the source db?

‏2012-05-04T17:52:36Z |
Hi folks,

I'd like to know if the aggregation work done by the "group by" operator takes place in the source database where the source dat resides or in the ISW server?

My source data table has millions of rows that I don't want to ship on the network. The Info Center doc doesn't say anything on this topic but I'd like to know one way or another before spending time to implement this operator.

Thanks in advance,

Gene
Updated on 2012-05-07T12:26:40Z at 2012-05-07T12:26:40Z by geneK
  • SystemAdmin
    SystemAdmin
    203 Posts
    ACCEPTED ANSWER

    Re: Does the "group by" operator push the aggregation down to the source db?

    ‏2012-05-07T02:26:36Z  in response to geneK
    hi Genek,
    If you connect a data source operator with group by operator directly, yes, the group by operation is accomplished in the source data server. Besides the group by operator, you can also specify the where condition and select list for the data source operator to restrict the data transferred to network.
  • geneK
    geneK
    7 Posts
    ACCEPTED ANSWER

    Re: Does the "group by" operator push the aggregation down to the source db?

    ‏2012-05-07T12:26:40Z  in response to geneK
    Great. Thank you very much, Qi.

    Regards,

    Gene