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: 28 Jun 2020