List:General Discussion« Previous MessageNext Message »
From:Denis Jedig Date:April 25 2013 5:50am
Subject:Re: Performance of delete using in
View as plain text  
Larry,

Am 25.04.2013 02:19, schrieb Larry Martell:

> delete from cdsem_event_message_idx where event_id in (....)
>
> The in clause has around 1,500 items in it.

Consider creating a temporary table, filling it with your "IN" 
values and joining it to cdsem_event_message_idx ON event_id for 
deletion.

Kind regards,

Denis Jedig
Thread
Performance of delete using inLarry Martell25 Apr
  • Re: Performance of delete using inDenis Jedig25 Apr
    • RE: Performance of delete using inRick James30 Apr
Re: Performance of delete using inLarry Martell25 Apr
  • Re: Performance of delete using inLarry Martell25 Apr