I've ran many different DELETE queries against many tables in the huge database (hundreds of millions records). What would be faster - to run OPTIMIZE TABLE against each modified table. Or just to mysqldump into the file and then restore back from the file?
Think that this will be equal. Just mysqldump | mysql will be faster ;)