16.20 - Bulk Qualification Enhancements - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine Release Summary

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Release Notes
featnum
B035-1098-162K

Bulk qualification, the process of evaluating single-table predicates on multiple column values in parallel, is now applied to these SQL DML request steps:

  • Retrieve, sum, and join steps on these tables:
    • Primary index row
    • No primary index row
    • Row spool
  • Sum and join steps on these tables:
    • Columnar primary AMP index
    • Columnar no primary index
    • Columnar primary index
    The retrieve step was supported in Release 15.10.

Bulk qualification uses single-instruction multiple-data (SIMD) parallel processing.

Bulk qualification may not be enabled in a step, based on restrictions. To detect whether bulk qualification was enabled in a step, users can check the InMemBulkQualStatus field of the QryLogStepsV view.

Benefits

This feature improves the CPU performance of retrieve, join, and sum steps.

Considerations

This feature is enabled only if In-Memory Optimization is enabled. In-Memory Optimization is disabled by default. To enable it, contact your Teradata representative.

Additional Information

For more information on the InMemBulkQualStatus field, see Teradata Vantageā„¢ Data Dictionary, B035-1092.