 |
 |
Archives of the TeradataForum
Message Posted: Wed, 17 May 2006 @ 19:28:42 GMT
| Subj: | | Re: Finding spool usage for each STEP in the explain |
| |
| From: | | Dieter Noeth |
Anomy.Anom wrote:
| | I'm rephrasing my question. If a query runs out of spool, how to identify the PeakSpool usage or a skewed AMP for a particular
STEP. | |
Which Teradata version?
In V2R6+ there's estimated vs. actual cputime/rowcount per step. A large rowcount indicates a large spool and a skewed spool usually has a huge
difference between HotAmp1CPU and LowAmp1CPU.
Dieter
| |
