Question: What is the main advantage of using a clustered index?

Options:

1. It allows for faster updates
2. It stores data in a sorted order
3. It reduces the need for normalization
4. It can be created on any column

Correct Answer: It stores data in a sorted order

Solution:

A clustered index stores data in a sorted order based on the indexed column, which can significantly improve the performance of data retrieval.