Archives of the TeradataForum

Message Posted: Fri, 27 Jul 2012 @ 14:08:19 GMT

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

Hi Sughesh,

From the information that you've given there is no way to answer the question.

What type of join criteria are being used (equality, inequality, between)?

Is there any selection criteria applied to either table?

What are the PI's of the two tables?

Are there statistics collected on the selection and/or join columns?

Cheers,

Dave

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

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