How to find data change frequncy in a table or column?

Database
Enthusiast

How to find data change frequncy in a table or column?

Q: Can anyone describe that how we can find the Data change frequency in table or column?

Example: I have a table with 5 columns and suppose 100 rows in my table next day i have added the 10 rows again next day i have added 10 rows and again next day i have delete the 5 rows or update 5 rows then finally how we can find that what is the data change frequency in table in respect of percentage?

Note: Based on this percentage we need to collect stats on table or column.

Tags (1)
2 REPLIES
Enthusiast

Re: How to find data change frequncy in a table or column?

I had exactly the same problem. U can't do it easily, just see my topic :
http://forums.teradata.com/forum/database/sql-history
Teradata Employee

Re: How to find data change frequncy in a table or column?

Hi,

I am using Teradata Database version 13.10, Is there a way to find how much percentage of data is modified.

Is there any query by which we can find this information.

Thanks in Advance!!