My requirement is below could you please help me with this.
I have a set of eg 10 tables; for each of the 10 tables, I need to get the stats collected on them.
1. Basically I get the tables created in past one week from DBC.Tables.
2. For each of these tables I need to get the statistics collected for them.
Stats details can be fetched from DBC.StatsV view and it has almost all stats details of the objects. If you still wanna get the details from DBC.StatsTbl, try the below query(change the where condition accordingly)
Select d.DatabaseNameI, t.TVMNameI, s.*
from dbc.DBase d join dbc.TVM t
join dbc.StatsTbl s