Archives of the TeradataForum

Message Posted: Wed, 23 Mar 2011 @ 11:29:52 GMT

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

Hi Sami,

There are so many approaches to tune a query which would actually depends on the scenario.

--> You can probably try to split the query by creating volatile tables/global temporary tables etc.

--> If the problem is with the target table you can check whether the most unique PI has been chosen or not such that the amp distribution should be balanced n good.

--> you can also try to split the query based on default/null values such that they are handled in separate inserts.

These are only few and there are many more.

Regards,

Sireesha

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