Adaptive Server Enterprise version 12.5.0.3 enables large-page allocation for the target table in select into, by allocating pages by extent rather than individual page, and thus issuing fewer logging requests for the target table. Instead of logging and updating information for each new page in sysindexes, Adaptive Server updates only once, to the last page in sysindexes, as the last operation in select into.
Although select into statements use a 2K I/O buffer pool by default, the optimizer can choose the largest pool possible, depending on the size of the buffer pools available in the target database cache. If you configure Adaptive Server with large buffer pools, it uses large I/O buffer pools for writing the target table pages to disk.
