 |
 |
Archives of the TeradataForum
Message Posted: Mon, 20 Oct 2003 @ 18:10:35 GMT
| Subj: | | Re: SQL Against Teradata via COBOL Program |
| |
| From: | | Arunachalam, Sankar |
Instead of validating against a table using select.. Try loading the look up columns in memory and do a binary search this would be many
folds faster.. or else load the data to be validated in a temp table and do the validation using bteq scripts.. Yes row-by-row processing
will really stink ... Avail of the unconditional parallalism to get past the stench..
| |
