Archives of the TeradataForum
Message Posted: Tue, 13 Jun 2000 @ 19:43:10 GMT
A good way to improve your query in V2R3 is to use 'volatile table', that new feature allow you to create your spool as you want (and can avoid hot AMP), some heavy query on our DWH has been dramatically improve, especially when we want to join small tables with a big one where the field in your 'where clause' have not the same layout.
Hope it help you.
DE LUCA CLAUDIO
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|