Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 02 Feb 2005 @ 11:18:23 GMT

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

Subj:   Re: Different Explains for the same query
From:   Victor Sokovin

  I am facing a peculiar situation where the SQL when run inside the macro runs in 1 min, but the same query when run as a Macro hangs up. Basically I am getting a different Explain when I run the SQL inside Queryman (better EXPLAIN) and a different Explain when I put the SQL inside a macro and run the macro instead.  

Try to run the query and the macro in bteq. If the explains remain the same, the problem is with the ODBC driver. If so, you can enable the ODBC tracing and see how the driver translates both requests before submitting them to TD. I second the other poster that for the purpose of this test you should make sure that the macro contains only one query.

If you still see the difference in explains and run times in bteq, it might be worth publishing more data.



  <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: 15 Jun 2023