Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Wed, 16 Jan 2013 @ 12:53:24 GMT


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


Subj:   Re: Effectiveness of NOPI
 
From:   Dave Wellman

Hi Sughesh,

It probably depends on exactly what you're doing.

Using a NOPi allows a fastload operation to use significantly less cpu and IO, anything between 10 and 60% less in test results that I've seen.

However, the fastload process is typically only part of the processing, you then need to read this data and join and/or insert it into other tables. This subsequent processing tends to go a lot slower if the staging table is NOPI compared to a reasonable PI.

Overall the testing seems that for most circumstances using a NOPI table uses a lot more CPU and IO.


Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)



     
  <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: 24 Jul 2020