Archives of the TeradataForum

Message Posted: Wed, 19 Dec 2007 @ 14:01:47 GMT

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

     Diagnostic helpstats on for session;

Then run your explain. As a caveat, be cautious about collecting all the recommended statistics. If they don't help your access path, don't keep them - it just costs CPU cycles to keep collecting extra stats.

Ruth

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