Example: Using ExpStatsV - Teradata VantageCloud Lake

Lake - Database Reference

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ohi1683672393549.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
ohi1683672393549

This example assumes the following statistics are collected:

      STATISTICS
      COLUMN CAST(o_orderdatetime AS DATE) AS Stats_OrderDate
      ON Orders;

This query can be used to retrieve the statistics collected on single expressions:

SELECT * FROM dbc.ExpStatsV
       WHERE databasename = 'sales'
         AND tablename = 'orders';