Effect of ascending inserts

When it inserts rows in ascending order, Adaptive Server avoids index searches by remembering the last insertion point. This provides a hint for subsequent inserts because they can verify the insertion point to be the one next to the last inserted row.