Home Forums SQL Server 2014 Development - SQL Server 2014 Query runs faster in MASTER but slow in my own database. RE: Query runs faster in MASTER but slow in my own database.

  • January 23, 2017 at 3:28 am

    #1924347

    Thanks.

    The two plans are completely different.

    Many of the tables have no indexes at all. In addition toaccelerating queries, indexes provide SQL Server with information and withinsufficient information the optimiser may not be able to guarantee a good plan,which is the case here. At the very least, some or all of those tables shouldhave a clustered index.

    Just curious – the cardinality estimator differs, it’s 120for the fast “master” query and 70 for the slow “sword” query…

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden