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: wubin...@gmail.com http://www.mysqlsupport.cn China 发件人: F.A.I.Z.A.L 发送时间: 2010-04-13 16:52:28 收件人: mysql; mysql-help 抄送: 主题: difference btw Analyze and Optimize table.. 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