Archives of the TeradataForum

Message Posted: Wed, 22 Oct 2003 @ 19:01:25 GMT

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

Hi ,

When I do a 'sample' in a query, does this save on spool space or does the server build the entire set in the spool and then return the specified 'sample' ?

e.g.

select * from table
sample 100

Thanks

Lucian

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