| Difference between Index Rebuild online and Coalesce [message #59797] |
Tue, 23 December 2003 12:34  |
scott
Messages: 73
Registered: September 1999
|
Member |
|
|
An academic question again
Can someone tell me the difference between rebuidling an Index online and Coalescing an Index. From what I understood after reading the Oracle Docs both do the same the only difference that I found was that Rebuild online takes a few more steps and is more sophisticated
Thanks in advance
Scott
|
|
|
|
| Re: Difference between Index Rebuild online and Coalesce [message #59811 is a reply to message #59797] |
Wed, 24 December 2003 05:53  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Rebuilding = rebuilds the index and needs 2x the space(old and new) to complete the operation.
Coalesce = reclaim space within the index by coalescing the leaf blocks and placing the empty leaf blocks into the free list. Simpler and doesnt need 2x space .
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
