Example: Using MultiColumnStatsV - Teradata VantageCloud Lake

This example assumes the following statistics have been collected:

 STATISTICS
   COLUMN (o_orderkey, o_orderdatetime)
      ON Orders;

This query can be used to retrieve the statistics:

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