Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 10 Sep 2001 @ 15:38:05 GMT

  <Prev Next>  
Next> Last>>  

Subj:   SELECT vs. Temporary Table
From:   Igor Matejov


I will be very tanksful for your advise on this issue - We are defining Views on historic tables in Teradata Data Warehouse and we have an issue with performance: We need to select ALL the transactions from the historic table that were valid in certain date. Afterwards we join these transactions with other 4 - 5 tables.

Q1) Does it make difference (in the way database works with data) if I put this date = 'XXX' condition into WHERE clause or into join statement (A JOIN B ON A.a = A.b AND A.date = 'XXX')?

When we use one select to create the view, it does not work because of the [NO MORE SPOOL SPACE] issue. So we suggested to use temporary tables, but we can not agree whether to use:

1) Different view, which will select the items with the certain date and then join this View with other tables or

2) To create TEMP tables into which we will insert items selected based on the date and then run the join select.

Can anybody advise me which will be better (or if there is really big difference in these approaches)?

Thanks in advance,


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020