16.00 - Dropping Statistics - Teradata Studio

Teradata Studio User Guide

Teradata Studio
March 2017
User Guide

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.