Case study – 753x faster!

Problem: Slow stored procedure

75,336% improvement in stored procedure performance!

Improvements achieved:
• CPU from 18,922 to 1,249
• Reads from 12,850,589 to 18,532
• Duration from 30,682 to 685

What was changed?

A SELECT with four JOINS became two SELECTs using a UNION.

It’s not 1 thousand times faster. But it is close!

That’s it. That simple!

Check out more case studies here!



I am an Enterprise SQL Server Database Administrator with 10+ years of experience working with complex transactional environments.

Leave a Reply

Your email address will not be published.

Contact Us