Set the variance threshold to ignore minor differences in estimated cost and spool size, making it easier to identify significant plan differences.
If the percent difference at any step is above the specified variance threshold, the cost and row size differences are highlighted. Plans where all of the differences are less than the threshold variance show up as matching plans.
1 From the Bulk Compare report viewer, click .
The Set Variance Threshold dialog box appears.
2 Enter a percentage in the Cost Estimate box.
3 Enter a percentage in the Size Estimate box.