Hi,

I have a table in which inserts/updates or deletes are taking place very frequently( in the order of 10000/sec) , Now I want to have the information on how many inserts or updates or deletes took place in the table.

I might ask for a query like how many inserts took place on a specific date or for a date range.

I know that I can use triggers to collect this information. But is it advisable to use triggers on a table where there are frequent operations. If not what is the other alternative ?


Prem

Reply via email to