Drop Statistics - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.11
Published
May 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
xjy1467322272664.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.