hi River thanks for your mail.
could you please tel me the correct syntax for optimize table command. i plan to put this in cronjob and execute every 8 hours in a day. optimize table tab1; is that correct or anything need to add with his statement. my environment is solaria Cheers Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com On Tue, Apr 13, 2010 at 2:37 PM, River wubx <[email protected]> wrote: > 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: [email protected] > 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 >
