An optimization case in which it takes 142 seconds to delete 0 records by walking the index in the database.
This article mainly shows you the "optimization case of deleting 0 records in the database but taking 142 seconds". The content is simple and easy to understand and the organization is clear. I hope it can help you solve your doubts. Let Xiaobian lead you to study and learn the article "optimization case of deleting 0 records in the database but taking 142 seconds".
There is a timed deletion SQL on the BI database, the purpose of which is to delete data one month ago (that is, the data in the table is only retained for one month):
delete from table1 t where t.update_date
