• Ok, so in other words you're saying a clustered index means that the physical data is stored in index order, so e.g. binary searches are possible.

    A nonclustered index is closer to what you'd expect of the meaning of "index": a separate list with a pointer to the physical record.

    That does clear up a lot...