Performance of an Aggreartor

Under what conditions selecting sorted input in aggregator will still not boost session performance ?

Questions by BRAHMAIAH   answers by BRAHMAIAH

Showing Answers 1 - 3 of 3 Answers

Ahmed Husseiny

  • Aug 31st, 2014

If the input rows are already distinct keys. i.e. input rows count = output rows count

  Was this answer useful?  Yes


  • Sep 16th, 2014

If in session property Incremental agg. is enabled. 2. in case of Nested aggregation 3. if treat row as data driven is selected in session property. In all of above cases aggrigator performance wil not be boosted up though its using sorted i/p.

  Was this answer useful?  Yes

Venkateswara Rao

  • Oct 14th, 2014

If all the rows belong to the same data group . Then it doesn't improve anything

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions