Re: Optimize table statement
Posted by:
abilash vs
Date: October 08, 2010 01:27AM
Thanks Rick & Shawn for all your replies.
Can I conclude my understanding as below,
1)Optimize applies mostly to MyISAM tables and has limited usefulness for InnoDB tables.
2)There can be possibility that Optimize can help Innodb tables if 'innodb_file_per_table' is switched ON from beginning.As I am using single InnoDB tablespace (ibdata1) and not using innodb_file_per_table,the free space will anyways be reused as rows are inserted into any table.
Correct me if I am wrong.
Thanks in advance,
Abilash
Subject
Written By
Posted
September 09, 2010 01:30AM
September 10, 2010 02:28PM
September 11, 2010 10:15AM
September 21, 2010 06:44AM
September 21, 2010 03:41PM
September 22, 2010 06:58AM
September 22, 2010 07:35PM
September 23, 2010 12:10AM
September 23, 2010 08:48AM
Re: Optimize table statement
October 08, 2010 01:27AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.