Poor performance when query contains anti-join on a complex predicate in SQL Server 2014 SP1

Symptoms

Assume that you run a query that contains anti-join clauses on a complex join predicate, such as conjunction of inequalities. If you run this query in SQL Server 2014 Service Pack 1 (SP1) with a 4199 trace flag enabled, you experience poor performance because of a sub-optimal query plan. 

Resolution

This issue is fixed in the following service pack for SQL Server:


About service packs for SQL Server
About service packs for SQL Server

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

Learn about the terminology  that Microsoft uses to describe software updates.
Vlastnosti

ID článku: 3170043 – Posledná kontrola: 11. 7. 2016 – Revízia: 1

Microsoft SQL Server 2014 Service Pack 1

Pripomienky