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
.

Relevant Pages

  • Re: Desktop file is replicated on every start
    ... Enquire, plan and execute ... Run Disk Defragmenter. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: question about ramdisk
    ... The instructions are always executed from RAM even if the executable ... file is on a physical disk. ... Execute ... send the line "unsubscribe linux-kernel" in ...
    (Linux-Kernel)
  • Re: Norton internet security, the Norton tech installed it remotle
    ... Enquire, plan and execute ... In Disk Defragmenter click on Analyse and see if there is a populated ... Run Disk CleanUp in all user profiles before running Disk ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Force programs to run only in memory?
    ... Enquire, plan and execute ... Is it possible to force programs into and run from RAM? ...
    (microsoft.public.windowsxp.general)
  • Re: message???
    ... Enquire, plan and execute ... RAM I will have to buy more RAM to verify the veracity of the report.. ...
    (microsoft.public.windowsxp.general)