thanks to you and everyone involved in this mail thread.. after optimize the table. i can see huge performance improvement..
thanks again.. Cheers Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com On Tue, Apr 13, 2010 at 11:35 PM, Suresh Kuna <sureshkumar...@gmail.com>wrote: > 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 >