Although they are useful when more than 5% of the rows of a file must be retrieved,clustering indexes are harder to maintain than a non-clustering index when data is modified.

Question

Quizplus · Accepted Answer

Clustering indexes dictate the physical order of data, so if the data is modified, the physical order may need to be changed, which can be time-consuming and resource-intensive. Non-clustering indexes, on the other hand, simply point to the physical location of data, so they are easier to maintain when data is modified. Therefore, the statement is true.

Although They Are Useful When More Than 5% of the Rows