• Some of the things I'd check:

    * are statistics updated?

    * is the table indexed? Are they indexed well?

    * Are there unnecessary indexes?

    * compression

    * partitioning

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP