Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 06 Mar 2003 @ 19:00:15 GMT

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

Subj:   Re: Access Logging and Denials
From:   Geoffrey Rommel

  We would like to verify how a table is getting accessed to check whether or not an index is being utilized.  

You probably know this already, but you cannot find this out directly from the Access Log; you would have to examine the explanations of the queries or use QCD.

  So I went in and tried turning on any access to that table through WinDDI....  

In order to find out what is currently being logged, query the view DBC.AccLogRules. It's described in the Data Dictionary Reference.

  <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: 28 Jun 2020