Archives of the TeradataForum
Message Posted: Thu, 05 Jan 2006 @ 17:20:21 GMT
| Subj: || || Re: Different Explain plan for different users - SAME SQL |
| From: || || Victor Sokovin |
| ||Does anyone have any ideas on why two different users, with different access methods would receive differing explains - and sporadically,
on the exact same statement, on the exact same dataset, with no changes to anything else?|| |
Just a quick suggestion: check the default session parameters for all users. My guess is that the "slow" user might be using ANSI transaction
mode, not the TD mode, and/or perhaps some other settings which override the "fast" defaults. In such cases you might end up with nasty (and
unnecessary) conversions of dates, character sets etc.
To check this conjecture just include SHOW SESSION somewhere in the beginning of the scripts executed or simply use the DBA utilities to
monitor the sessions and their parameters.