List:General Discussion« Previous MessageNext Message »
From:River wubx Date:April 13 2010 9:07am
Subject:Re: difference btw Analyze and Optimize table..
View as plain text  
OPTIMIZE TABLE tablename;
analyze table  ,stores the key distribution for a table ,reclaim the unused space and to defragment the data file.

ANALYZE TABLE tablename;
This action only analyze table and stores the key distribution for a table.

2010-04-13 



River wubx  
Gtalk: wubingxi@stripped
http://www.mysqlsupport.cn 
China



发件人: F.A.I.Z.A.L 
发送时间: 2010-04-13  16:52:28 
收件人: mysql; mysql-help 
抄e.. 
 
hi all
what is the difference between
OPTIMIZE TABLE tablename;
and
ANALYZE TABLE tablename;
thank you
Cheers
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
Thread
difference btw Analyze and Optimize table..F.A.I.Z.A.L13 Apr
  • Re: difference btw Analyze and Optimize table..River wubx13 Apr
    • Re: difference btw Analyze and Optimize table..F.A.I.Z.A.L13 Apr
      • RE: difference btw Analyze and Optimize table..misiaQ13 Apr
  • Re: difference btw Analyze and Optimize table..Suresh Kuna13 Apr
    • Re: difference btw Analyze and Optimize table..F.A.I.Z.A.L15 Apr