Archives of the TeradataForum
Message Posted: Thu, 29 Dec 2011 @ 16:04:07 GMT
SVC = Single Value Compression (e.g. "compress 0").
MVC = Multi-Value Compression (e.g. "compress (0,1,2,3,4)")
You asked which tables need compression. In general, compression is needed only for relatively large tables. On a one-node system where the largest table is 200 GB or so, you probably only need to have compression on about 10 tables.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|