I'd geneate create table with data and stats statements for step 1.
Al Czajkowski Solution Architect, Teradata
Attachments
Library
Quick Reference
Archives
Sample Index
2011 Indexes