Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 13 May 2008 @ 14:47:17 GMT


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


Subj:   Re: Regarding Access count in DBC.TVFields
 
From:   Saqib, Najam Us

Rahul,

The field "Access Count" remains 0, if access count facility is not enabled. By enabling access count facilty, this field start getting incremented with each hit on column, table or database by the user queries. In order to get daily or weekly access frequency of column, table or database, we take snapshot of DBC.TVFields, DBC.DBASE, DBC.TVM and DBC.INDEXES and then reset access count field in these tables.


Regards

Najam



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023