Archives of the TeradataForum
Message Posted: Thu, 12 Sep 2002 @ 14:03:39 GMT
Is there anyway to tell if a new column being added to the end of a table that's marked as NOT NULL DEFAULT ' ' COMPRESS ' ' is actually getting compressed.
I do an INSERT/SELECT from CURRENT to NEW table and new table has 15 new columns added to the end define as above. I usually don't see an increase in DASD use, but this time the table size increased by 54 GB as if compression didn't happen on the new columns.
Thanks in advance, Tony.
Anthony S. Howe
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|