Archives of the TeradataForum

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

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

Hi,

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,

Igor

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