 |
 |
Archives of the TeradataForum
Message Posted: Thu, 28 Oct 2004 @ 11:13:54 GMT
| Subj: | | Re: Diagnostic Statement to Turn Hash Joins Off For a Session |
| |
| From: | | Victor Sokovin |
Clay,
| | Does anyone know the syntax to turn hash joins off for a session via the diagnostic syntax? If so, would they mind sharing it with
me? | |
I'm sure you know all this but just to clarify: you need to set the HTMemAlloc to 0 on an individual session level? Temporary reset of
the DBS parameter is not what you are looking for because you don't want the change to take place on the database level, not even for a short
time?
Regards,
Victor
| |
