Archives of the TeradataForum

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

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

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>>