Currently in our project, the change log retention is done for one year. But it is occupying huge amount of space. Please let us know the best practices for retention of change log table data in production system. What would be the ideal period for which change log data needs to be retained.
Thanks in advance!