Archives of the TeradataForum

Message Posted: Thu, 14 Dec 2006 @ 17:26:16 GMT

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

Yes but will the solution be faster than the DISTINCT?

If not you could look up similar threads in the archives. There should be examples showing that DISTINCT can sometimes be replaced by GROUP BY. Depending on the data distribution (and the database release) this may help.

OLAP functions might be useful to explore as well.

The optimal method depends on your specific data and its distribution so some testing is always a good idea.

Regards,

Victor

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