Archives of the TeradataForum
Message Posted: Mon, 17 Mar 2003 @ 15:55:55 GMT
It is true that the PI takes no physical space. I think that the difference that you're seeing may be due to 'blocking factor' (for want of another phrase). In your table which has more columns in the PI, there will be (typically) fewer rows per block, and I think you'll find that there are more data blocks used. These data blocks will occupy more disk sectors, which is the reason that you find one table has a larger CurrentPerm than the other. You should be able to check this with the Ferret / Showblocks command.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|