Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Odd behavior -- execution plan different when I execute in the target database vs not in the target database RE: Odd behavior -- execution plan different when I execute in the target database vs not in the target database

  • May 8, 2018 at 11:04 am

    #1989747

    Jason A. Long - Monday, May 7, 2018 9:23 PM

    TheSQLGuru - Monday, May 7, 2018 6:05 PM

    Maybe DB2 has the same objects and something different (like 10000X more data, missing indexes, different data types, etc)?

    The best way to help you is to post the query plans.

    Good to see you back Kevin! Hope all is well.

    Thanks for asking Jason, but sadly no. 🙁 But I miss helping the SQL Community out so I have decided to pick one to respond to now and again.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service