Peter Maloof (7/5/2011)
David:I have to disagree that a phone book is an unclustered index.
Unless I'm mistaken, the white pages contain data physically sorted by
last name, first name and address. Once you access the entry
you're looking for, you have all the data; there's no bookmark to follow.
Maybe I'm misunderstanding something, but that sounds like a clustered index to me.
Thanks,
Peter
Peter,
I think the information we are looking for is the hat size rather than the phone number. Once we use the index to get the phone number we then have to use the phone number to get the information. He mentioned the physical houses are not in order which is why it wouldn't be clustered.
Jess