Database Administration Question:
Download Questions PDF

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.

Download Database Administration Interview Questions And Answers PDF

Previous QuestionNext Question
Explain What is a tablespace?Tell us Do you need a commit after DDL statements?