Setting the Variance Threshold - Visual Explain

Teradata Visual Explain User Guide

Product
Visual Explain
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2504
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.