Re: Enhancement Request

[Ron Johnson <ronljohnsonjr@xxxxxxxxx>]

On Wed, Jan 31, 2024 at 3:51 PM Hajek, Nick <Nick.Hajek@xxxxxxxxxx> 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).