 |
 |
Archives of the TeradataForum
Message Posted: Tue, 20 Sep 2000 @ 00:28:37 GMT
| Subj: | | Re: Access logging and utilities |
| |
| From: | | Sam Mosley |
Do your users query through views? Could the deletes, inserts, and updates that you want to log be done through views? Most
utility work is done directly against tables. Assuming you have views in a different database than the tables, you can turn on
access logging against the view database(s), and not have to worry about logging the activity that is directly against the tables.
You don't mention logging the selects, or other activity, but you may also want to log other activity as well. If you log every user
request (but not utility work) it will add some overhead, but if you are using the Teradata to do data warehouse work (not oltp) then
it really shouldn't be much of a problem. Adding a second or two to a query that runs 60 seconds to hours is not noticeable.
Sam Mosley
President VLDB Systems, Inc.
| |
