drop statistics in teradata

Database
Enthusiast

drop statistics in teradata

I have some multi dimensional statistics defined on a column which i want to drop from the table so i need to drop this statistic first......

Can you tell me the DROP Statement for statistics ?

Is the statement
"""drop statistics on 'table_name' column('column_name')"""
or it needs some modification ...........

help need urgently

Thanks in advance
3 REPLIES
Enthusiast

Re: drop statistics in teradata

This is one way of dropping a multi column stats. (There's one more syntax)

DROP STATISTICS ON MyTable COLUMN(col1, col2);

you will notice that the syntax is similar to the collect stats syntax.
Enthusiast

Re: drop statistics in teradata

Hi All,

 

If statistics is dropped on one table then

1)Will it be a case of data lose?

2)Will it take more time when it loads data in next run?

 

Regards,

Bhavini.

Senior Apprentice

Re: drop statistics in teradata

Hi Bhavini,

 

1) No. Dropping stats does not remove any data.

 

2) It depends, but usually 'No'. If you are loading the table with Fastload/TPT Load/Multiload/TPT Update then No. If the table being loaded is also one of the source tables in an Insert-Select then 'maybe'.

 

HTH
Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com