Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 05 Jan 2006 @ 17:20:21 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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.



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020