Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 05 Jan 2006 @ 18:21:15 GMT

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

Subj:   Re: Different Explain plan for different users - SAME SQL
From:   Al MacGowan

Thanks for the information. I'm not sure I'm any further ahead yet, however.

As for statistics: the tables, rows, simultaneous workload(none), and statistics are identical in the case of both queries. I've tried collecting, dropping and recollecting, etc - I've not been able to make a difference... We're on V2R5.1.2, so hopefully the redistribution bug isn't applicable. Could there be anything about a connection type, or a sessionmode that could cause a difference in an execution plan? Silly, as it sounds, I'm really hitting a wall with what could possibly be different between the two access methods that would cause a differing execution.

Alistair MacGowan
Senior Database Administrator

  <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