Hi MySQL Fans ;-);
Does anybody understand what the QUICK option is doing when used with the DELETE command ? It says in the manual "..no MERGEing of INDEX leaves during delete".
Sorry, but I could not make any sense out of this. Could somebody please be so kind to enlighten me ?
I guess it is related somehow to optimizing the index or space of a table.
It may make the query quicker because the server doesn't do as much messing around fixing up the leaves of the index tree.
Best regards -- --- Valentin Nils Internet Technology
E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
