 |
 |
Archives of the TeradataForum
Message Posted: Mon, 27 Jul 2009 @ 20:28:35 GMT
| Subj: | | Re: Compression and Alter |
| |
| From: | | Dieter Noeth |
Anomy.Anom wrote:
> ID CHAR(10) COMPRESS (mykey) and
> ID CHAR(10) COMPRESS (mykey ) -? Please note 5 spaces.
If you add single quotes around the value, yes :-)
| | What abt altering a big table for compression: - Can it be done in these cases - | |
| | -- Adding new values to already compressed column | |
| | -- Altering table to compress a column already present to be compressed first time. | |
Both yes, since V2R6.2
Dieter
| |
