Database Administration Question:
Explain What is index cluster?
Answer:
An index cluster uses an index to maintain data within the cluster. The structure of a cluster index is similar to a normal index.
Although a normal index does not store NULL key values, and index cluster can store it.
And, a cluster index is likely to be smaller than a normal index because, there is only one entry for each key value in the cluster index, even if that is repeating.
Although a normal index does not store NULL key values, and index cluster can store it.
And, a cluster index is likely to be smaller than a normal index because, there is only one entry for each key value in the cluster index, even if that is repeating.
| Previous Question | Next Question |
| Explain What is a tablespace? | Tell us Do you need a commit after DDL statements? |