There is command 'Optimize Table' in MySQL. What is the equivalent of
this in Oracle?
And if none, how to optimize an Oracle (10g) table?

Thx.

<mansoor531 (AT) gmail (DOT) com> wrote

Jim

<mansoor531 (AT) gmail (DOT) com> wrote

Jim

<mansoor531 (AT) gmail (DOT) com> wrote

Jim

<mansoor531 (AT) gmail (DOT) com> wrote

Jim

On Jan 31, 9:19 am, mansoor... (AT) gmail (DOT) com wrote:
truncate

Guaranteed to speed along any operation.

-bdbafh

On Jan 31, 9:19 am, mansoor... (AT) gmail (DOT) com wrote:
truncate

Guaranteed to speed along any operation.

-bdbafh

On Jan 31, 9:19 am, mansoor... (AT) gmail (DOT) com wrote:
truncate

Guaranteed to speed along any operation.

-bdbafh

On Jan 31, 9:19 am, mansoor... (AT) gmail (DOT) com wrote:
truncate

Guaranteed to speed along any operation.

-bdbafh

On Jan 31, 8:56*am, "news.verizon.net" <kenned... (AT) verizon (DOT) net> wrote:
Had one decided to use google.com one would have found this:

http://dev.mysql.com/doc/refman/5.0/...ize-table.html

wherein the OPTIMIZE TABLE command is explained. Basically it repairs
split (chained/migrated) rows, compacts free space, repairs indexes
and updates table statistics. Thus, in 10.2 and later releases, which
create statistics automagically, an

alter table <tablename> move;

followed by an

alter index <indexname> rebuild;

would perform similar 'magic'. Of course the antiquated exp/drop/imp
scenario could still be used to 'optimize' the table. In either case
the table is unavailable for use during the operation as both products
lock the object for the duration of the process.


David Fitzjarrell