TD Studio- Object List Viewer-Access Count

Teradata Studio
Enthusiast

TD Studio- Object List Viewer-Access Count

Hi, Everyone, Could anyone tell me the meaning of the "Access Count" and "Last Access " of the Object List Viewer? the name of the introduction documents about all dbc tables is also helpful. Thank you very much.

Accepted Solutions
Teradata Employee

Re: TD Studio- Object List Viewer-Access Count

Hi,

From Studio perspective those columns shows the information about the object.

Access count :    Shows how many times the object been accessed.

Last Access:        Show the time stamp of when the object is last time accessed.

 

You will need to have enabled Query Logging with OBJECTS to capture this information in the data dictionary (DBC). 

 

Thanks 

1 ACCEPTED SOLUTION
3 REPLIES 3
Teradata Employee

Re: TD Studio- Object List Viewer-Access Count

Hi,

From Studio perspective those columns shows the information about the object.

Access count :    Shows how many times the object been accessed.

Last Access:        Show the time stamp of when the object is last time accessed.

 

You will need to have enabled Query Logging with OBJECTS to capture this information in the data dictionary (DBC). 

 

Thanks 

Teradata Employee

Re: TD Studio- Object List Viewer-Access Count

And the name of the manual with information about DBC tables is Data Dictionary. 

Highlighted
Enthusiast

Re: TD Studio- Object List Viewer-Access Count

Thank you for your reply. I have already downloaded it