Archives of the TeradataForum
Message Posted: Tue, 13 Dec 2005 @ 14:46:03 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|