Teradata Software for 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. 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 it after deploying Teradata Database.
- Manual indicates you must install and configure the feature using the Teradata Database documentation, similar to on-premises systems.
The following table does not include Teradata Database features that are enabled by default and are automatically installed and configured, such as Fallback.
| 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. | Yes for premium storage. No for local storage. |
Automatic for premium storage. Manual for local storage (not recommended). |
|
| Teradata Columnar™ | Provides the ability to partition a table or join index by column. | Yes | Automatic Must be configured. |
|
|
Teradata Intelligent Memory™
[Advanced, Enterprise tiers] |
Speeds query performance and maximizes system memory by ensuring the most frequently used data is kept in memory. | No1 |
Automatic |
|
| Teradata Row-Level Security | Allows you to restrict data access by row in the Teradata Database. | No1 |
Automatic |
|
| Teradata Secure Zones | Provides grouping of user and database hierarchies into separate database partitions with restriction of user access to one or more zones. | No1 |
Automatic |
|
| Teradata Temporal | Provides built-in capabilities that are required in a temporal database management system. | No1 | Manual | Temporal Table Support |
| 1Can be enabled when deploying Teradata Database. | ||||