Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020