Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 29 Dec 1999 @ 12:56:17 GMT


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


Subj:   Re: Vproc Usage
 
From:   Andy Blevins

You need to look at the query or queries that are running and see what type of access they are using. It is possible for example to have a large table using a NUPI that has very even distribution on the system. The NUPI could be on customer ID which would mean all customer numbers that were the same would be on the same AMP. Someone could then try and access all customer numbers that start with 99 or access the data by not using the index which could cause the query to appear to be running against skewed data.



     
  <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