Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 06 Jan 2006 @ 15:35:30 GMT


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


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

I wanted to thank all of you for your assistance with this topic. We finally got enough of a persuasion with management to say that there was enough reason to rewrite the 6 minute query that sometimes runs 4 hours, into a 3 second query, that we can't make run any longer than 3 seconds, and send it back through QA/Test.

Unfortunately, I do not have any information as to why two different sessions get different execution paths on 100% identical data/stats/circumstances. I'm hoping to not have to worry about it again (being REALLY hopeful).


Thanks again!

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: 23 Jun 2019