Re: Optimize Table

From: news.verizon.net <kennedyii_at_verizon.net>
Date: Fri, 01 Feb 2008 04:38:45 GMT
Message-ID: <pnxoj.7772$z_6.1061@trnddc06>

<mansoor531_at_gmail.com> wrote in message news:3f65d008-6ee3-49d7-95ff-00c20d9dcc53_at_s12g2000prg.googlegroups.com...

> On Jan 31, 8:35 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:

>> On Jan 31, 8:56 am, "news.verizon.net" <kenned..._at_verizon.net> wrote:
>>
>> > <mansoor..._at_gmail.com> wrote in message
>>
>> >news:b31143cc-e006-4b0a-9d21-dc36a2550c3f_at_y5g2000hsf.googlegroups.com...>
>> >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.
>>
>> > What does optimize table in your sql do?
>> > Jim
>>
>> Had one decided to use google.com one would have found this:
>>
>> http://dev.mysql.com/doc/refman/5.0/en/optimize-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

>
>
>
> Will the alter table <tablename> move; command work without specifying
> any tablespace name?
>
> Also how would you rebuild all the indexes of a table without
> specifying or knowing the names of indexes.
>
> I'm searching google but so far haven't found anything.
>
> Thanks
>
>
>
>

There are ways but why? What problem are you trying to solve? Jim Received on Thu Jan 31 2008 - 22:38:45 CST