@mackuba.eu But the MySQL docs for EXPLAIN command don’t mention anything like that (Postgres does delete data in this case). I found one StackOverflow answer that mentions it, and one question on MySQL mailing list without answer.

GPT claims it does work this way, but can only point me at the same two links…