Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 13 Dec 2005 @ 11:09:56 GMT

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

Subj:   Re: Global Temporary Tables (GTT) and Statistics
From:   Victor Sokovin

  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.  

This sounds to me like the keyword TEMPORARY is not used in the COLLECT STATISTICS statement. Just refer your colleague (or whoever asked the question) to the SQL Reference DDL Statements manual. The syntax is explained pretty well there, and because syntax differences are rather subtle in this case and may depend on the context of the request, why not just consult the manual and try the options it discusses?



  <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: 28 Jun 2020