Teradata Database Features

Teradata Database on Azure offers many 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 image, you still need to install and configure it.

The following terms are used in the table below:
  • Automatic indicates you do not have to install or configure the feature and can begin using the feature after a Teradata Database VM is deployed.
  • 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 a feature are noted.

Teradata Database features that are enabled by default and are automatically installed and configured are not included in the table below. Fallback is mandatory for all Teradata Database license tiers and cannot be disabled.

For information on how to install and configure the listed features, see the Documentation column.
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 for premium storage.

No for local storage.

Automatic for premium storage.

Manual for local storage (not recommended).

Teradata Database Administration
Fallback Protects data in case of AMP vproc failure.

See Introduction to Teradata.

Yes Automatic SQL Data Definition Language Syntax and Examples
Teradata Columnar Provides the ability to partition a table or join index by column.

See Release Summary for Teradata Database 14.0.

Yes 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.

  • Utilities
  • Teradata Intelligent Memory Orange Book
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

Can be enabled when deploying a Teradata ecosystem.

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

Can be enabled when deploying a Teradata ecosystem.

Automatic

Security Administration
Teradata Temporal Provides built-in capabilities that are required in a temporal database management system. No

Contact Teradata Customer Support to enable (Base, Advanced, and Enterprise tiers only).

Manual Temporal Table Support

results matching ""

    No results matching ""