Default Feature Status| Advanced SQL Engine 17.10 - 17.10 - Default Feature Status - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Release Definition

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Release Notes
Publication ID
B035-1725-171K
Language
English (United States)

In previous releases, some features were enabled by default and others were manually enabled, depending on whether the Vantage system had a fresh installation (sysinit) or an upgrade.

Default enabling may cause changes in system behavior compared with previous releases. Even after enabling, some features may require additional configuration.

Teradata Vantage 1.1 and later features do not require a sysinit to be enabled. Features in earlier releases that required a sysinit still require a sysinit.

Feature Use Log (FUL) is automatically enabled with Default Logging for all license tiers, for both sysinit and upgrade. The syntax to enable or disable FUL is still supported, but will be a no-op because FUL is now always logged whenever default logging is enabled.

Feature License Tiers Upgrade Sysinit Effects and Comments
OVERRIDE ON ERROR Not Applicable Upgrade: Enabled

Sysinit: Enabled

OVERRIDE ON ERROR has become the default when creating tables. If a user names an invalid map when creating a table, the system uses the default map for the user, role, or profile instead. If there is no default map for the user, role, or profile, the system default map is used.
Always Fallback Not Applicable Upgrade: Disabled

Sysinit: Enabled

Fallback behavior and defaults have become platform-specific. Newer platforms always use fallback, even if you specify NO FALLBACK. Older platforms that upgrade to this release still allow the NO FALLBACK option, and the default is NO FALLBACK for CREATE TABLE, ALTER TABLE, CREATE JOIN INDEX, CREATE HASH INDEX, CREATE DATABASE, MODIFY DATABASE, CREATE USER, and MODIFY USER requests.
In-Memory Optimization Developer: Not Applicable

Base: Not Applicable

Advanced: Not offered

Enterprise: Included

Upgrade: Disabled

Sysinit: Disabled

In-Memory Optimization is enabled when the appropriate license and memory are purchased.

To enable, contact Teradata Support Center.

Temporal Developer: Included

Base: Included

Advanced: Included

Enterprise: Included

Upgrade: Disabled

Sysinit: Disabled

To enable, contact Teradata Support Center.
After Temporal is enabled, it cannot be disabled.
Teradata Secure Zones Developer: Included

Base: Included

Advanced: Included

Enterprise: Included

Upgrade: Disabled

Sysinit: Disabled

 
Teradata Database MAPS Architecture (MAPS) Developer: Not Applicable

Base: Included

Advanced: Included

Enterprise: Included

Upgrade: Disabled

Sysinit: Enabled

This feature is:
  • Enabled for new installations
  • Disabled by default on upgraded systems
To enable, contact Teradata Support Center. After this feature is enabled backdown is not supported.
When MAPS is enabled, you must use DSA for archive/recovery operations. For more information about DSA, see Teradata® DSA User Guide, B035-3150.
Adaptive Optimization Developer: Includes IPE

Base: Includes IPE

Advanced: Includes IPE

Upgrade:

Enterprise: Includes Enhanced IPE

Upgrade: Enabled for Enterprise

Sysinit: Enabled for Enterprise

Enhanced IPE provides:
  • Noncorrelated subqueries with small results sets
  • Single-row query blocks
  • Derived table or view produces zero rows or a single row
  • Spooled subqueries with smaller result sets
  • Advanced rewrites based on results feedback
Block loads between Row Level Security (RLS) tables and non-RLS tables Developer: Included

Base: Included

Advanced: Included

Enterprise: Included

Upgrade: Disabled

Sysinit: Disabled

To enable, contact Teradata Support Center.
IN-list Rewrite Developer Developer: Included

Base: Included

Advanced: Included

Enterprise: Included

Upgrade: Enabled

Sysinit: Enabled

To disable this feature, use DBS Control fields. For more information, seeTeradata Vantage™ - Database Utilities, B035-1102
TASM I/O Usage Event Developer: Not Applicable

Base: Not Applicable

Advanced: Not Applicable

Enterprise: Included

Upgrade: Disabled

Sysinit: Disabled

To enable, contact Teradata Support Center.

The appropriate license must be purchased first.

Intelligent Memory (TIM) Developer: Not Applicable

Base: Not Applicable

Advanced: Included

Enterprise: Included

Upgrade: Disabled

Sysinit: Disabled

TIM is enabled when the appropriate license and memory are purchased.

To enable, contact Teradata Support Center.

TVS (Hybrid Storage) Developer: Not Applicable

Base: Not Applicable

Advanced: Not Applicable

Enterprise: Included

Upgrade: Enabled

Sysinit: Enabled

TVS (Hybrid Storage) is enabled by default when using the hybrid storage system.
Concurrent Query Limit Developer: 2

Base: 15e

Advanced: None

Enterprise: None

Upgrade: Enabled

Sysinit: Enabled

Appropriate license must be purchased first.
Function Mapping Developer: Included

Base: Included

Advanced: Included

Enterprise: Included

Upgrade: Enabled

Sysinit: Enabled

Function mapping simplifies executing functions on foreign servers.
Teradata Analytic Functions Developer: Included

Base: Included

Advanced: Included

Enterprise: Included

Upgrade: Enabled

Sysinit: Enabled

Some scoring and predictive analytical functions are executed natively on Advanced SQL Engine. For details see Teradata Vantage™ - Advanced SQL Engine Analytic Functions, B035-1206.
Default DBQL Algorithm Not Applicable Upgrade: Enabled

Sysinit: Enabled

Changed from Alg 1 to Alg 3.
Native Object Store (NOS) Not Applicable Upgrade: Enabled

Sysinit: Enabled

WRITE_NOS is also enabled when NOS is enabled. It is only enabled on SLES 12 SP3 and if certain prerequisites are met.

If not enabled by default, contact Teradata Support Center.