Home Forums SQL Server 2005 T-SQL (SS2K5) UNION ALL performance issues - one table is NULL RE: UNION ALL performance issues - one table is NULL

  • July 17, 2015 at 2:25 pm

    #1813433

    There's not enough information here to give you a definitive answer.

    Could you post:

    1. The DDL for both tables

    2. The query plan produced when you do a SELECT * from <current table>

    3. The query plan produced when you query the view

    Let us know if you have questions about how to do this.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001