Archives of the TeradataForum

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

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

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