Archives of the TeradataForum
Message Posted: Wed, 28 Jul 2010 @ 17:17:04 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|