 |
 |
Archives of the TeradataForum
Message Posted: Mon, 13 Jun 2005 @ 13:30:24 GMT
| Subj: | | Re: Compression and join indexes |
| |
| From: | | Victor Sokovin |
| | Unfortunately, Join Indexes currently do not support field compression. This issue is addressed in RFC 82548 (created on 5/22/2003.) I'd
strongly recommend you contact your local Teradata Representative and encourage them to implement this feature (along with Join Index support of
Mutli-Column Stats, Sample Stats, PGB, PPI, Fast-Path Delete, co-existance with Triggers, etc :-) | |
Right; but if the OP's main concern is storage, and any method reducing storage requirements for the JI would do, then why not look into the JI
own compression mechanism? By this I mean that in the JI definition we can specify repeating groups of columns in parentheses. The details can be
found in the SQL Reference DDL.
This method has a priori nothing to do with field compression in the base table but it should help reduce the storage required for the JI.
Regards,
Victor
| |
