Execution time for PI and NoPI for 30 million records is same

Database
KVB
N/A

Execution time for PI and NoPI for 30 million records is same

Hi

I have loaded a table using with 4 million records a my source file with PI and with NoPI using TPT connection.It shows a gain.

When I load a 30 million record file with PI and with NoPI.It does not show much gain.Almost the execution times are same.

Any comments on this?

1 REPLY

Re: Execution time for PI and NoPI for 30 million records is same

Skew might be the distinguishing factor. Can you check the skew factor with the PI for the 4 million and 30 million records. if the skew percentage is high then it takes more time to load a PI based table than a NOPI table