Hello.
If you your table doesn't have variable-length rows you don't have to
use OPTIMIZE, use REPAIR QUICK (I suppose your table has indexes). See:
http://dev.mysql.com/doc/mysql/en/optimize-table.html
http://dev.mysql.com/doc/mysql/en/repair-table.html
"Suresh" <suresh@stripped> wrote:
> Hi Team,
>
> I would like to rebuild the tables which one will be suitable repair or
> optimize. Please suggest.
>
> Thanks in advance.
>
> Thanks
> Suresh
>
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
