Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 12 Dec 2005 @ 17:55:40 GMT


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


Subj:   Global Temporary Tables (GTT) and Statistics
 
From:   David Clough

I may have asked this before but I can't remember the response, so please forgive me if you remember the question.

What I want to do (or at least my colleague does) is to create a Global Temporary table and use Statistics on the 'invoked instance' from a particular session.

For example, in one particular session we might insert 0.5 Million rows into that GTT and use the session table in a subsequent Select statement. But, I want Teradata to be able to reasonably accurately estimate that 0.5 Million rows.

What seems to be the case is that you can Collect stats on the GTT definition (giving zeros rows) but once it's materialized you can't then create local stats.

Perhaps I just don't know how to use them properly. Can someone put me out of my misery ?


Dave Clough
Database Designer
Express ICS

www.tnt.com



     
  <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