What is the advantage of the clustered index?

Category: SQLWhat is the advantage of the clustered index?
Editor">Editor Staff asked 2 years ago

What is the advantage of the clustered index?

  1. It is fast to update the records.
  2. It does not need extra work for SQL queries.
  3. It minimizes the page transfer and maximizes the cache hits.
  4. None of the above is correct.
1 Answers
Editor">Editor Staff answered 2 years ago

Answer:
3. It minimizes the page transfer and maximizes the cache hits.
Explanation: A clustered index is actually a table where the data is stored in rows. It stores data in only one way based on the key values. It helps us to store data and indexes simultaneously but takes a long time to update the records. They are scan and index seek that minimizes the page transfer and maximizes the cache hits. Hence option C is the correct choice.