Monthly Archives: April 2011

Optimize Recursive CTE Query

We recently assisted a global ISV to address a performance issue related to a poor performing recursive CTE (Common Table Expression). The ISV wanted the query that was running in excess of 3 minutes to run in less than 15 seconds on their servers. The end result of our efforts was a 3,600% performance improvement. Continue reading

Posted in Thoughts | Tagged , , , , , , | Leave a comment