which is the worst performance function below ? A. Rank , B . RankCumulate, C. Sum , D. Select



  • Depends how you use them…
    RANK and RANKCUMULATE are generally worse-performing because they have to be performed on a single CPU thread where other functions can benefit from parallel CPU execution.

  • Dikshant

    All functions involving ranking are worst, but that does not mean that we should now use them; its just don't use it often and find for alternatives if you can.

    SUM, LOOKUP, SELECT used together in same line item gives worst performance.

    SELECT can be applied to top levels.