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

Options
sruthee
sruthee
in Modeling

Answers

  • MarkWarren
    MarkWarren
    Options

    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
    Dikshant
    Options

    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.

Categories