One reason is that in the old days (SQL 6.5 and before) the clustered index defined the order of the data within the table. There are other reasons out there, but this is the only one that I can think off at the moment.
What do you mean by a row locator? Can you provide an example?
Last Wiki Answer Submitted: December 2, 2007 12:02 pm by Denny Cherry64,520 pts.