Can anyone please explain what happens at the page level when clustered indexes are created? How do pages rearrange data once clustered indexes are created?

  • I asked a similar question, and I can't find it. IIRC the logical page manager links virtual pages to physical block pages, so they're not actually arranged in a clustered fashion on the physical medium. I found it to be kind of confusing too. Moreover, the records within the pages aren't actually ordered anyway (you have to look up the slot array) Anyway good luck on this one. Mar 21 '18 at 5:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.