Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 20 Sep 2000 @ 00:28:37 GMT

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

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.

  <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: 15 Jun 2023