Archives of the TeradataForum

Message Posted: Thu, 08 Sep 2016 @ 21:07:35 GMT

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

Hi,

David Roth is correct that more information would be useful.
- the explain plan

Having said that, if you can give the stage table the same PI as 'tab2' then almost certainly it will run a lot more efficiently as you'll then have a PI:PI join. That is almost guaranteed to improve performance of this query.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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