Collect Stats - can you copy them?

Tools & Utilities

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.

Re: Collect Stats - can you copy them?

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