How to get ununsed column list from table.

Database

How to get ununsed column list from table.

Hi,

I am trying to find  ununused columns list from a table that are not being  accessed by anyone since it is created.

3 REPLIES

Re: How to get ununsed column list from table.

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.

Enthusiast

Re: How to get ununsed column list from table.

Raghu,

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.

Thanks!!

Re: How to get ununsed column list from table.

Hi Velu,

Thanks for the link. I will take a look at it.