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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql

Reply via email to