Home Dashboard Directory Help
Search

SQL 14 - Query hanging with new Cardinality Estimator by Tom Lucas - 0411


Status: 

Closed
 as Not Reproducible Help for as Not Reproducible


2
0
Sign in
to vote
Type: Bug
ID: 803739
Opened: 9/27/2013 3:57:52 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

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.


Details
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
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
query_hang_sql14_newCE.sql 9/27/2013 15 KB