Analyze table : Analyze table analyzes and stores the key distribution for a table.
For more details check the below URL http://dev.mysql.com/doc/refman/5.1/en/analyze-table.html Optimize table : OPTIMIZE TABLE is useful when we do more deleted operations on a table with variable columns. It will do the defragmentation of the data file and recliam the space. It sorts the indexes and updates the table statistics if it is not. However, the new inserts will reuse the deleted row space. For more details check the below URL http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html On Tue, Apr 13, 2010 at 2:21 PM, F.A.I.Z.A.L <sac.fai...@gmail.com> wrote: > 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 > -- Thanks Suresh Kuna MySQL DBA
