在步骤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 source table is large, this may cause an overflow of the logical log.
如果无法将排序的数据整个放入排序堆中(排序堆是每次执行排序时分配的一块内存),它就会溢出到该数据库所有的临时表中。
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.
应用推荐