Community

FIX: Incorrect Cardinality Estimates for NOT EXISTS Predicates After You Upgrade to SQL Server 2000 Service Pack 3

by SSWUG Research

After you upgrade to SQL Server 2000 Service Pack 3, the SQL Server query optimizer may incorrectly estimate the cost for queries that involve a predicate that uses a NOT EXISTS () construct. The estimate will be too high, and results in poorly performing queries as compared to SQL Server

Read More - Register for Free Membership

Tags:
Author: SSWUG ResearchSSWUG Research is the team that brings you SSWUG-based content and community links. Have an idea? Send us a note at sswugresearch@bitsonthewire.com - we'd love to hear from you.