I want to get the top 10 tables which are most frequently accessed in teradata .
I see accesscount column in dbc.tables but it is null for all the records.
Can someone give some pointers
You need to have access logging turned on in order for the system to gather that data directly. If you have query logging turned on you can write a grab the 62 characters after the from clause in the dbqlogtbl.