Re: Estimate temp space

On Fri, 06 Apr 2007 06:54:09 -0700, Cristian Cudizio wrote:

> column source, the algoritm it uses to estimate is the same, but to
> really view if it uses disk or ram
> you have to execute it.

Essentially, what explain plan gives you is the total estimated size of data to be sorted. It doesn't necessarily translate into the amount of the temp tablespace to be used. That would be extremely hard to estimate. The total size, however, is a significant help.

-- 
http://www.mladen-gogala.com