PPI

Database

PPI

Dear All,

It is said in Teradata Design manual that "bulk data loading times are greatly reduced by finer PPI granularity"

Can anyone explain the above said statement?

Regards
Santosh A Sardesai
2 REPLIES
N/A

Re: PPI

Hi Santosh,
this is true if the table is partitioned by date and your loading current data.
Then all the data is for a single (and probably empty) partition.

Dieter

Re: PPI

Hi,

Yes. you are right. but if i partition data by day instead of month. whats the reason the load is faster for day partiton than month

can you please explain

Regards
santosh