Archives of the TeradataForum
Message Posted: Wed, 16 Jan 2013 @ 12:53:24 GMT
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)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|