| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: What is the difference between shrinking an index and rebuilding in Oracle 10g?
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
 |
 |