Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Advice on query optmization - Multiple Unions RE: Advice on query optmization - Multiple Unions

  • March 30, 2016 at 8:14 am

    #1868622

    Is there a table on a linked server?

    If so, it may be better to pull the necessary data into a temp table and then do the unions.

    Also, the subselects with the top 1, may be better to do an outer apply.

    I would test this if I had some DDL.

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]