SQL 14 - Query hanging with 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 803739 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 9/27/2013 3:57:52 PM
Access Restriction Public


I have a query which is hanging under new cardinality estimator in SQL 14(compatibility=120), which returns in about 10 seconds using previous CE (compatibility = 110).  This is for the same sql server where I filed a similar bug #801676.  This is the same sql server and database as this bug, but a different query.

Sign in to post a comment.
Posted by Microsoft on 11/14/2013 at 5:48 PM
Hi Tom,

Closing on this issue as the physical design of hte dbs changed.