Archives of the TeradataForum

Message Posted: Thu, 28 Aug 2003 @ 14:40:28 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Object access..

From:		Anomy Anom

<-- Anonymously Posted: Thursday, August 28, 2003 10:00 -->

Greetings!

I am trying to find out obselete objects in our databases.

I could see fields AccessCount and Lastaccesstimestamp in the DBC.TVM and DBC.tvfields tables. It is mentioned in the documentation that these fields contains information when the object was last accessed and how many times it was accessed.

Can any one tell in what cases these fields get populated. I could see Null values in our site . None of objects have these values populated.

One more thing, I am trying to find out NUSI's that are not being used across the system.

For that I am trying to find out Value access (How often that column appears in equality condition) and Value access frequency (How often annually all known transactions access rows through this column).

Is there easy way to find out about these demographics in V2R4?

I guess we can do this through Index wizard and query logging in V2R5,

Appreciate help on this.