SQLPerformance.com by SentryOne
The Answers.SQLPerformance.com Q & A site has been made read only. Read about the process.
Please visit our support site to ask new query tuning or Plan Explorer questions.

Plan 2 of 2; Would like some ideas for improving the performance of this query.

Ernest 2013-05-09 19:48:40

/storage/attachments/432-tmp2426.queryanalysis
GregGonzalez 2013-05-09 22:21:31
Please post the actual plan for this one as well.
May 9, 2013
No Comments

Post navigation

Plan 1 of 2; Would like some ideas for improving the performance of this query.
Doing quite a bit calculations in a single step, is there a better way?

Recent Posts

  • What’s wrong with 2014’s Cardinality Estimate here?
  • identical plans different performance
  • DISTINCT clause degrading performance
  • Why such poor performance from same query in different databases
  • Business objects query with EXCEPT runs slow

Recent Comments

    Archives

    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • April 2017
    • March 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • October 2016
    • September 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • July 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • February 2015
    • January 2015
    • December 2014
    • November 2014
    • October 2014
    • September 2014
    • August 2014
    • July 2014
    • June 2014
    • May 2014
    • April 2014
    • March 2014
    • February 2014
    • January 2014
    • December 2013
    • November 2013
    • October 2013
    • September 2013
    • August 2013
    • July 2013
    • June 2013
    • May 2013
    • April 2013
    • March 2013
    • February 2013

    Categories

    • Uncategorized

    Meta

    • Log in
    • Entries RSS
    • Comments RSS
    • WordPress.org
    SentryOne
Sponsor & Curator
    Design and content © 2012-2019 SQL Sentry, LLC.  All rights reserved.  User contributions are licensed under cc-sa with attribution required.