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

Teradata Vantageā„¢ - Advanced SQL Engine Release Summary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
olo1596850177299.ditamap
dita:ditavalPath
olo1596850177299.ditaval
dita:id
B035-1098
Product Category
Software
Teradata Vantage
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.