It is said that when a clustered index is created,the table is copied and the data in the table is sorted and then the original table is deleted.So what happens when a new record is created.Is this process continues?
When a new row is inserted, it will be put on a page according to its place in the clustered index. If there is no room on the required page, then a page split occurs.
John
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply