Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Mon, 16 Jun 2003 @ 21:22:04 GMT





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




Subj:   Re: Trying to discourage FTS
 
From:   Ballinger, Carrie



Clay,

In terms of data blocksize, the join index is treated just as any other table. A join index will use the system-level default blocksize similar to what a base table with no blocksize specification would use. Unless you've changed it, this is probably 64K -- the default in DBSControl.

Thanks, --Carrie





     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008