• Your question is a bit broad.

    I'd suggest you start reading a book, such as SQL Server 2012 Query Performance Tuning.

    I'm also pretty sure if you enter "sql server query tuning" in Google, you'll get a lot of results. Just a hunch.

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