16.00 - Dropping Statistics - Teradata Studio

Teradata Studio User Guide

prodname
Teradata Studio
vrm_release
16.00
created_date
March 2017
category
User Guide
featnum
B035-2041-126K

Dropping statistics permanently removes statistical data that has already been collected for specified columns and indexes of a table.

  1. Open the Query Development perspective.
  2. In the Data Source Explorer, select the tables or columns and indexes for which you wish to drop statistics. You can select more than one table or more than one column and index by holding the Ctrl or Shift key while you click.
  3. Right-click a selected object, and click Teradata > Statistics > Drop.
  4. If you clicked one or more tables, the Drop Statistics dialog opens to allow you to select the column and index statistics to drop. After you have selected, click OK.
  5. In the Drop Statistics confirmation message dialog, click OK.