rows affected by SQL - Query Log

UDA
Enthusiast

rows affected by SQL - Query Log

Which dbc/log table has how many rows inserted/updated/deleted by given sql for given period.

Teradata Version: V2R6
1 REPLY
Enthusiast

Re: rows affected by SQL - Query Log

It might not be the same for every installation in my view. For example in a situation where tracking is enabled like Tracking System Events, Tracking Logon Rules or audit trails the tables like DBC.Sw_Event_Log etc might be the most active. Another scenario is when access logging is activated.