Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 13 Jun 2000 @ 19:43:10 GMT


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


Subj:   Re: Hot Amp
 
From:   Claudio De Luca

Claudia,

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
OSD ODSS
DATABASES MANAGEMENT



     
  <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: 27 Dec 2016