• In PAT (pre-PROD) environment.

    performance is terrible.

    77 rows returned in 2 min and 56 sec..

    Very slow...

    Execution Plan is attached...