Archives of the TeradataForum

Message Posted: Fri, 07 Jan 2011 @ 14:00:30 GMT

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

Is it possible for you to post the EXPLAIN plan of this SQL.

There might be columns which are being used in JOINS but are not part of PI. Have you collected stats on them as well? If not, then try that. Also, is the data huge in these tables?

Lakhwant

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