|
|
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.
| |