I have 100+ tables in my databse. I want to generate stats on the tables basd on index/partition/join and where clause. Is there any table/view prsent in DBC to give me this list or any genralized query.
I know DBQLOBJTBL will give me TypeOfUse. How do I decide out of all records that it gives.