Whats are the consequences/side effects of deleting STALE records from Oracle DB with Large Data?

This may sound like a silly questions.
However, one of the easiest solutions to keep my data consistent is to delete STALE records from my DB Table. My table has millions of row.

Can anyone please tell me consequences/side-effects of deleting data from DB.

This DB will be heavy read and medium writes.

Any predictions or 2 cents here before I learn it the hard way on the production website?

[UPDATE]
One of the plausible solutions I have in mind is:
I have always have options of adding another column to determine if the data is stale or not. However, with this solution, I need to keep track of another variable.


Source: sql

Leave a Reply