Setting the Variance Threshold

Teradata Visual Explain User Guide

brand
Teradata Tools and Utilities
prodname
Visual Explain
vrm_release
16.10
16.20
category
User Guide
featnum
B035-2504-086K

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.