Archives of the TeradataForum

Message Posted: Wed, 28 Jul 2010 @ 17:17:04 GMT

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

An effective way to let the optimizer do its job is to make sure the proper statistics are taken and possibly to instantiate derived tables as real or volatile tables. If you've got control of the SQL (say you're not running a tool that generates it), break the SQL down until it does what you need.

iv

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