CheckTable Enhancements | Advanced SQL Engine 17.10 | Teradata Vantage - 17.10 - CheckTable Enhancements - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine Release Summary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Release Notes
Publication ID
B035-1098-171K
Language
English (United States)
CheckTable is enhanced to:
  • Report dictionary errors in batch mode.
  • Optionally skip the dictionary check.
  • Optionally skip the user table check.
  • Use more parallel sessions for user table checking.

Benefits

  • Provides the capability of achieving high concurrency of table checks when executed on large systems.

SQL Changes

New keywords are added to the CheckTable syntax:

  • MAXSESSIONS
  • SCOPE { DICTIONARY | USER | ALL }

Additional Information

For more information, see the CHECK command in Teradata Vantageā„¢ - Database Utilities, B035-1102.