 |
 |
Archives of the TeradataForum
Message Posted: Mon, 17 Mar 2003 @ 15:55:55 GMT
| Subj: | | Re: Primary index and table space |
| |
| From: | | David Wellman |
Hi,
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.
Cheers,
Dave
| |
