Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: What is difference between Sample 10 and Top 10?
From:   sughesh iyyani

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020