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.
President VLDB Systems, Inc.