Archives of the TeradataForum

Message Posted: Fri, 07 Jan 2011 @ 22:05:33 GMT

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

You could try using the following before running the query, it will point out any additional stats that might be needed to be completed.

Run 'diagnostic helpstats on for session;'

Then run explain

Look at the end of the explain for any recommended stats.

To turn off the diagnostic, just logoff the session.

Cheers,

Mark

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