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.


2
0
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

Description

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.

Regards,
Richard