在步骤4中,我们使SORTHEAP加倍到2048以避免排序溢出,因为某些查询需要创建临时表。
In Step 4, we doubled SORTHEAP to 2048 to avoid sort overflows because some queries needed to create temporary tables.
如果无法将排序的数据整个放入排序堆中(排序堆是每次执行排序时分配的一块内存),它就会溢出到该数据库所有的临时表中。
If the sorted data cannot fit entirely into the sort heap, which is a block of memory that is allocated each time a sort is performed, it overflows into a temporary table owned by the database.
如果源表很大,那么这可能导致逻辑日志的溢出。
If the source table is large, this may cause an overflow of the logical log.
应用推荐