Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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.



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

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020