What to do with the records in the database after deletion if the information about them is useful in the future?

Question

Database

After deleting the user's ad, information about it will be needed for statistics.
What to do in this case, hide? If so, how much can it slow down the search for ads?
Move to another table for statistics? It's probably enough to do it once a day and how to implement a function that will run once a day
Or something else?

Answer 1

It is better to move them directly when deleting, so they will not hang out and you will not have to discard them in all requests.

Answer 2

How many ads are we talking about?
I believe that if the record is simply hidden and the search is done only on non-hidden ones, there will be no fatal slowdown.