The unchanging and ever-increasing attributes of the clustered index are certainly important considerations and are the ideal practical case, very true. Let's consider that amendment 1 to what I...
Just consider that the clustered index reorganizes the entire table so that the rest of the row content is physically on the same pages or nearby, in the order of...