To copy the table in teradata with all stats and data , can use
create table product_1 as product with data and stats;
There are two ways to approach this.
If you are about to create the table copy, you should go with the syntax mentioned above:
Create Table DatabaseName.Table_Copy as DatabaseName.Table With Data And Stats;
If however the table copy is created with data and you want to copy the STATS afterwards, in TD 14 and above, you can use the following syntax:
Collect Stats DatabaseName.Table_Copy From DatabaseName.Table;
It is to be noted that the table definitions (Table_Copy and Table) should be the same