Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 05 Jul 2006 @ 14:20:59 GMT


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


Subj:   Questions about Volatile tables
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, July 05, 2006 10:10 -->

I'm using a volatile table as an appropriate way of improving throughput in a particular set of circumstances.

I have 2 questions:

- The population of this volatile table takes x time for a given primary index set of columns, though with a PI that would improve performance even more, it is taking at least 30x (not strictly controlled conditions, but stable enough). It is known to be in the MERGE step; i.e. populating the volatile table. This discrepancy seems extreme for redistribution based on different hash values??

- Can one look at the volatile table; perhaps even it's size or something else by which the progress of populating can be monitored? I'ma aware that volatile tables are not controlled as fully as normal tables in the data dictionary etc, but surely there must be some way of detecting their presence?


Many thanks



     
  <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