On Wed, Jan 31, 2024 at 3:51 PM Hajek, Nick <Nick(dot)Hajek(at)vishay(dot)com> wrote:
[snip]
> Delete from table1 where table1.id in (select table1.id from table1
> limit yourlimitnumber)
>
The IN predicate is only efficient for a very small number of
elements, supported by an index. People (including me) who would find
DELETE FROM .. LIMIT TO ... useful want to delete a *lot* of rows (but not
all in one giant statement).