This example assumes the following statistics have been collected:
STATISTICS INDEX (o_orderkey) ,INDEX (o_custkey, o_orderstatus) ON Orders;
This query can be used to retrieve the statistics:
SELECT * FROM dbc.TableStatsV WHERE databasename = 'sales' AND tablename = ‘orders’;