How to get most frequently accessed tables in Teradata

General
Enthusiast

How to get most frequently accessed tables in Teradata

Hi,

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

Thanks

1 REPLY
Enthusiast

Re: How to get most frequently accessed tables in Teradata

Rad,

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.

Cheers

B