LOW_PRIORITY
Optional. If LOW_PRIORITY is provided, the delete will be delayed until there are no processes reading from the table. LOW_PRIORITY may be used with MyISAM, MEMORY and MERGE tables that use table-level locking.
QUICK
Optional. If QUICK is provided, ndex leaves are not merged during the delete making the deletion faster for MyISAM tables.