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.


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

Description

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.

Regards,
Richard