Re: when is the proper time to execute optimize table command ?
Posted by: Krunal Patel
Date: September 17, 2015 06:33AM

Actually, We need to do use OPTIMIZE TABLE table_name command, to do de-fragment the fragmented tables, and remove the unnecessary space from the physical files(*.MYI & *.MYD).
It's batter to use it when less or none DML statements execute over the fragmented table.
In Result of using OPTIMIZE TABLE table_name command, you can reduce the Size of Physical files, and improve the performance.

Options: ReplyQuote

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.