Archives of the TeradataForum
Message Posted: Thu, 06 Mar 2003 @ 19:00:15 GMT
| 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.