Archives of the TeradataForum

Message Posted: Wed, 05 Jan 2011 @ 16:25:24 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

In Teradata 13 you can

Copy statistics from one table to second table that has identical columns and data types Copying statistics from one column to an identical column or index

     COLLECT STATISTICS ON target_table_name [column_list] FROM [TEMPORARY]
     source_table_name [column_list];

     COLLECT STATISTICS [column_list] ON target_table_name FROM [TEMPORARY]
     source_table_name [column_list];

	<Prev	Next>		<<First	<Prev	Next>	Last>>