my queries are too slow when SET FORCEPLAN OFF

Question

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Andrew G SSChampion Points: 12809 More actions · Answer 1

Ok, so we're only looking at 5MB of data for the subquery. What about the estimated query plan for the modified query? Is it still going wrong?

Thinky Night SSCommitted Points: 1663 More actions · Answer 2

Execution Plan with subquery is in the attachments. But Universe Engine could not generate those queries like subquery.

As a last choice, i will import execution plan with FORCEPLAN ON onto the engine.

Thinky Night SSCommitted Points: 1663 More actions · Answer 3

microsoft suggested to open 4199 trace flag. But we are going to monitor system.