Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 02 Nov 2012 @ 20:47:48 GMT


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


Subj:   Re: Query on NUSI
 
From:   narayan.murthy

There is no problem with the hashing, it is to do with the access - single/two amp access for a USI or an ALL amp operation for a NUSI.

When accessing a NUSI an ALL amp operation is initiated to access the index subtable rows in each of the amp. From the index subtable, the base row ids pointing to the base table rows within the same AMP are accessed(thereby avoiding relocating of the base table rows in another AMP). Thus making the NUSI subtable as AMP local.

This is different when we access a USI, wherein it is a single/two amp operation. First the respective amp for a given index value is accessed and then the index subtable is probed to get the base table row which 'may' reside on the same amp(single AMP operation) or may reside on another amp(two amp).

Narayan
Wipro



     
  <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: 15 Jun 2023