Re: difference btw Analyze and Optimize table..

[River wubx]

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