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. |