All Forums Tools
epfatboy 1 post Joined 10/09
02 Oct 2009
Collect Stats - can you copy them?

Is there a way to copy STATS collected on a table to a duplicate table?

We have a process which we refer to as CLONE TABLE Processing. Basically when we are required to modify a large table rather than performing an ALTER TABLE we create a new table with the new attributes required and perform a FASTLOAD or INSERT INTO.

The process to duration to make the changes this way out performs ALTER TABLE for large tables. the problem is collecting stats takes a long time. We are also noticing that table sizes increase dramatically if we alter table vs performing clone table processing. In a recent example we increased a table size by 100GB by adding a single attribute using alter VS CLONE... very strange.

mahesh mankala 11 posts Joined 03/08
10 weeks ago

use the TSET to copy the stats from old table to new table

You must sign in to leave a comment.