Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 10 Sep 2001 @ 16:43:22 GMT

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

Subj:   Re: SELECT vs. Temporary Table
From:   James Judge

It definitely makes a difference whether the date criteria is in the ON statement versus the WHERE clause. Rather than a temp table have you tried a "derived table"? In your example the A table(view) could be a "derived table" (which is the SELECT SQL for that table/view stated in the FROM clause, check the reference manuals).

  <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