Teradata Database on VMware offers many Teradata Database features including, but not limited to, those listed in this topic. Not all features listed below are included in all Teradata Database tiers. See Teradata Database License Tiers. Although the package is included in the Teradata Database VM, you still need to install and configure it.
- Automatic indicates you do not have to install or configure the feature and can begin using the feature after a Teradata Database VM is launched.
- Manual indicates you must install and configure the feature using the Teradata Database documentation, similar to on-premises systems. Features that require Teradata Customer Support to enable are noted.
The following table does not include Teradata Database features that are enabled by default and are automatically installed and configured, such as Fallback. See Fallback. Fallback is mandatory for all Teradata Database license tiers and should not be disabled, as it can potentially result in data loss.
Database Feature | Description | Enabled by Default | Installation and Configuration | Documentation |
---|---|---|---|---|
Block-Level Compression | Stores data blocks in compressed format to save storage space and improve performance. See Release Summary for Teradata Database 14.0. |
Yes Although this feature is disabled by default for on-premises, it is enabled by default for private cloud. |
Automatic | Teradata Database Administration |
Teradata Columnar | Provides the ability to partition a table or join index by column. See Release Summary for Teradata Database 14.0. |
No | Automatic Must be configured. |
SQL Data Definition Language Syntax and Examples |
Teradata Intelligent Memory | Speeds query performance and maximizes system memory by ensuring the most frequently used data is kept in memory. See Release Summary for Teradata Database 14.10. |
No Contact Teradata Customer Support to enable. |
Manual Must be configured. |
|
Teradata Row-Level Security | If purchased, allows you to restrict data access by row in the Teradata Database. See Release Summary for Teradata Database 14.0. |
No | Automatic | Security Administration |
Teradata Secure Zones | Provides grouping of user and database hierarchies into separate database partitions with restriction of user access to one or more zones. See Release Summary for Teradata Database 15.10. |
No | Automatic | Security Administration |
Teradata Temporal | Provides built-in capabilities that are required in a temporal database management system. | No Enable at the time you deploy. This feature is available only for Base, Advanced, and Enterprise tiers. |
Manual | Temporal Table Support |