There is a table - DBC.ObjectUsage for object count but I don't see any data in it. Is there any other DBC table that stores columns in a table that are accessed using select queries?
I don't know much on Teradata administration , any help would be bery much appreciated.
Enable DBQL Object Usage to track all object level activity
Refer Teradata document for more details:http://www.info.teradata.com/HTMLPubs/DB_TTU_14_10/index.html#page/Database_Management/B035_1093_112...
Collect Qrylog for couple of weeks and take your analysis on Table/Index/View/Column usage from DBC.ObjectUsage.