Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 22 Apr 2003 @ 04:49:33 GMT

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

Subj:   Re: Select * from mytable
From:   Prabhjot_Sodhi

Select * is an all amp retrieval. Only queries based on Unique Primary Index are a single AMP operations.

The result set is returned from the RDBMS after the entire query is fetched and the information is available in the SPOOL 1. If the you check the explain for the query, the informatio is first built in the spool, sorted (if required) and then sent back to the user.

If the user wants to see only the 200 rows use RANK or a cursor for the same.

  <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: 27 Dec 2016