Starting with Teradata 14.0, a new feature was introduced called Columnar. Using a partition primary index (PPI), Teradata partitions tables into rows. But now you can also partition tables column wise.
Columnar provides you with this feature. You can now partition tables with a high number of columns into smaller tables. This not only reduces the I/O, but space too, by auto compressing column containers. Tables can be row partitioned plus column partitioned.
Advantages of using the Teradata Columnar can be the following:
- Improved query performance
- Reduced disk space
- Reduced I/O
- Ease of use
Please note there are certain features of Columnar that are not available in later versions of the database but are ...
