Unused tables

General
Enthusiast

Unused tables

Hi,

I want to find all the tables which are no used for the past 3 months .How to find this information in teradata

Thanks

2 REPLIES
Enthusiast

Re: Unused tables

You can use dbqlobjtlb if you have history.

Rglass

Enthusiast

Re: Unused tables

second option is, If you are in 14.10 or higher with enabling Autostats, you can find from objectusage table.