There's more...

Expression stats can be collected on:

  • CASE statements
  • Aggregation expressions, like SUM, MAX, and so on
  • With built-in database functions like date, current_dateand so on
  • UDF
To see expression stats, use the dbc.statsV or show stats command.

Get Teradata Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.