Archives of the TeradataForum

Message Posted: Tue, 29 May 2012 @ 14:32:28 GMT

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

Hi Experts,

Thanks a lot for the info provided.

I am tuning a big query with 8 joins and some derived tables.

If I put sample or top in this query (in between), will it increase the performance.?

As per my understanding it will take sample / top from the spool.

Query should give all the output to spool., then take samples from spool.

So will it improve the performance?

Which one will be better?

Thanks in advance,

Sughesh I S.

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