Re: Large Dataset - Estimated 87TB needed for TEMP - suggestions?

From: Sayan Sergeevich Malakshinov <>
Date: Tue, 27 Jan 2015 18:12:45 +0300
Message-ID: <>

> Also, it completed successfully for period 20142 but the explain
> plan for that one said it would need 573 TB of TEMP space so now I
> realize I have zero way to "guess" how much temp space it really
> needs but that 150 GB isn't enough.
> The stats are accurate for 100% estimation so I'm not sure why the
> estimate on the temp space is so high.

How different are values of "A-Rows" from "E-rows"? It seems that you have to gather extended statistics on (STS_PROVIDER,STS_PROGRAM_NO) and on

Best regards,
Sayan Malakshinov
Received on Tue Jan 27 2015 - 16:12:45 CET

Original text of this message