Archives of the TeradataForum

Message Posted: Tue, 14 Jul 2015 @ 20:13:00 GMT

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

Use the sample capability -- Sample 1e8 or Sample 100000000 -- to capture the data.

Top N is not a random sample, but it is slightly faster in this circumstance.

The sampling adds one step to your Explain.

Rgrds,

Bill Gregg

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