Effects of ascending inserts

You can set ascending inserts mode for a table, so that pages are split at the point of the inserted row, rather than in the middle of the page. Starting from the original table shown in Figure 39-2, the insertion of “A,4” results in a split at the insertion point, with the remaining rows on the page moving to a newly allocated page, as shown in Figure 39-6.

Figure 39-6: First insert with ascending inserts mode

Inserting “A,5” causes a new page to be allocated, as shown in Figure 39-7.

Figure 39-7: Additional ascending insert causes a page allocation

Adding “A,6”, “A,7”, and “A,8” fills the new page, as shown in Figure 39-8.

Figure 39-8: Additional inserts fill the new page