Quote Originally Posted by Thomasps
I dont' think you need to COMPUTE statistics for a large table rather use ESTIMATE with 10% - 20%. See the syntax from Tamil, how to ESTIMATE Statistics. I felt 20GB Temp space is something pretty big.
Even 10-20% may be over doing it. For many tables you'll get good statistics with 1-5%