Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 13 Dec 2005 @ 14:46:03 GMT


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


Subj:   NoDerivedStats
 
From:   David Clough

First of all, thanks for the replies about Collecting Stats on Global Temporary tables - I've now got it working.

On a slightly different issue (although not altogether unrelated to the previous question), does anyone know what the "noderivedstats" system setting does ?

I know how to set it on and off but nobody that I know seems to know precisely what it actually does as such.

What I thought it might have something to do with is to dynamically allow the optimizer to change tack based up stats that it gathers from Spool at time of execution, but I'd be guessing.

One of these days, perhaps I'll answer a question rather than just ask questions. In the meantime, thanks for any responses.


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