 |
 |
Archives of the TeradataForum
Message Posted: Thu, 29 May 2003 @ 22:13:17 GMT
| Subj: | | Re: Query In Dispatch without visible SQL |
| |
| From: | | John Hall |
The spool would only increase during the SELECT phase. If your job is performing the INSERT, then you wouldn't expect any change to
spool.
You can check the perm space to determine if the INSERT is being performed - it should be increasing. While you're checking perm space,
make sure that the work is evenly distributed across the AMPs - your job might be hot-AMPing.
| |
