Archives of the TeradataForum
Message Posted: Tue, 03 Dec 2002 @ 17:40:48 GMT
| Subj: || || Spool - Whole Row or Required Columns? |
| From: || || Gary Ramsay |
We are not sure whether it is the entire row that satisfies the relevant criteria that is copied to spool or only the specified columns.
This obviously makes a big difference to the amount of spool required but the Explain only gives estimated number of rows.
I can't find anything definitive in the electronic documentation for V2R4 - can anyone help?