In this article, Lipowitz demonstrates the unusual case where gathering statistics, and gathering statistics alone, drastically changes execution plans.
How Sampling Error Impacts Execution Plans: The Effects of Estimating Optimizer Statistics
Home / Educational Content / Database & Technology / SELECT Journal / How Sampling Error Impacts Execution Plans: The Effects of Estimating Optimizer Statistics