|
|
Archives of the TeradataForum
Message Posted: Thu, 29 Dec 2005 @ 20:49:43 GMT
Subj: | | Re: FastExport and the number of sessions vs. skewing |
|
From: | | Victor Sokovin |
| As you noted, OUTLIMIT is applied on the client side as data is being returned. You'll need either need a higher spool space limit or a SQL
change (e.g. added WHERE criteria) to limit the size of the result set. | |
The FastExport manual contains an example of how to do it. It can be found in "Using Checkpoints in a Single Export Job".
Checkpoints can also save time when the job needs to be restarted after a failure.
Regards,
Victor
| |