• Gail,

    Just to clarify- if physical order for clustered index in not always the same as logical order (and I read this before) why in this case page split happens while updating/inserting new records? Or am I missing something? Thanks,