Nested Loop Join Heuristics
Not always the cheapest execution plan gets chosen. This blog post describes such an edge case in SQL Server and Oracle. Continue Reading
SQL Server
Anomaly in Cost Calculation of Anti Semi Join With Nullable Columns
The SQL Server optimizer cost calculation of Anti Semi Join over null columns may produce bad execution plans if max server memory is set high. Continue Reading