16.00 - Drop Statistics - Teradata Studio

Teradata Studio User Guide

Teradata Studio
March 2017
User Guide

The Drop Statistics dialog drops statistics on selected columns and indexes on which statistics are currently defined. You can select either single or multiple objects to drop the statistics.

The Drop Statistics dialog is opened by selecting tables from the Data Source Explorer and right-click to select Teradata > Statistics > Drop Statistics.

Use these options to drop statistics:
Option Description
Dropping statistics on a table If all columns and indexes of a table from the currently displayed statistics objects are selected, the drop statistics process automatically submits Drop statistics on table SQL.
The table summary statistics are deleted during this operation.
Dropping statistics on individual columns or indexes You can select either single or multiple statistics objects that are displayed under each table object. Clicking OK starts the drop statistics process on individual columns and indexes.