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