Home Dashboard Directory Help
Search

Query hangs using new cardinality estimator by Tom Lucas - 0411


Status: 

Closed
 as Not Reproducible Help for as Not Reproducible


1
0
Sign in
to vote
Type: Bug
ID: 801676
Opened: 9/19/2013 5:22:13 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

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.
Details
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
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
query_plan_new_ce.xml 9/19/2013 363 KB
query_plan_old_ce.xml 9/19/2013 458 KB
query_hang_new_ce.sql 9/19/2013 4 KB