Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What is the difference between shrinking an index and rebuilding in Oracle 10g?

Re: What is the difference between shrinking an index and rebuilding in Oracle 10g?

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 11 Jan 2007 14:56:40 -0800
Message-ID: <1168556200.835370.316020@i39g2000hsf.googlegroups.com>

jout..._at_gmail.com wrote:
> What is primary difference in results from the following commands? It
> seems like they both resolve fragmentation issues.
>
> ALTER INDEX <INDEX_NAME> SHRINK SPACE;
>
> ALTER INDEX index_name REBUILD;
>
> ALTER INDEX index_name COALESCE;

Did you look it up in the documentation available at http://tahiti.oracle.com ?

Tom Kyte also has info if you search for it at http://asktom.oracle.com Received on Thu Jan 11 2007 - 16:56:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US