3. |
What is the key difference between rebuilding and index and coalescing an index?
Please select the best answer.
|
|
A. |
Coalescing an index saves more space.
|
|
B. |
Rebuilding an index causes the index to be put in sorted order, while coalescing an index does not sort the index values.
|
|
C. |
Rebuilding an index works on the whole index, while coalescing an index only affects the leaf blocks. |
|
D.
|
Rebuilding an index works on the whole index, while coalescing an index only affects the index nodes.
|