 |
 |
Archives of the TeradataForum
Message Posted: Fri, 29 Oct 2004 @ 15:15:58 GMT
| Subj: | | Re: Diagnostic Statement to Turn Hash Joins Off For a Session |
| |
| From: | | Dieter Noeth |
Claybourne Barrineau wrote:
| | Currently, I know it is possible to turn off certain types of joins for a given session if you issue the appropriate diagnostic statement.
However, I don't know if this is possible for Hash Joins. If so, I'm unawarer of the approriate diagnostic syntax. | |
If you open bin\par1.dll in a text editor you'll find all those diagnostic keywords.
Two of them are HSJOIN and HSJFEATURE, but a DIAGNOSTIC .. NOT ON FOR SESSION didn't seem to work :-(
Dieter
| |
