Archives of the TeradataForum

Message Posted: Wed, 22 Sep 2004 @ 16:54:14 GMT

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

You could increase the priority of the session running the insert/select, if you can tolerate a relative decrease in priority for the other active work. It should complete sooner as it will have faster access to resources.

You do this by changing the performance group name for the session either through Teradata Manager or PMON. If all your user-submitted work is running at the default priority of $M, you could move this session to performance group $H, for example. To give it even more support, you could change the assigned weight of the allocation group that $H points to, allocation group 3, from its default weight of 20 up to 35. Just make sure $R's allocation group (#4) has a slightly higher weight.

Thanks, --Carrie

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