Query hangs using new cardinality estimator - by Tom Lucas - 0411

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 801676 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 9/19/2013 5:22:13 PM
Access Restriction Public


I have a query which returns in 15 seconds using the old CE, and it is hanging using the new CE.  By hanging, I mean that it runs for over an hour and then fills up tempdb.  

This query represents a common query pattern for our application.  So, there are many others which fall into the same pattern, and hang with the new CE.  
Sign in to post a comment.
Posted by Microsoft on 11/14/2013 at 4:38 PM
Hi Tom,

We've closed the item tracking this issue as the new CE actually performs better than the old.