Archives of the TeradataForum
Message Posted: Sat, 26 Apr 2003 @ 16:05:46 GMT
Some one earlier in the week asked for a formula that could help assess how much perm space a join index will take. Here's one that a couple of people I know put together a few years back. I have not personally validated its accuracy, but I believe it will put you in the ballpark. It assumes the compressed format is being used.
Something else to keep in mind is the spool space required to build the join index. With multi-table JIs it can be up to double the size of the final JI structure.
Join Index Size = U * (F + O + (R * A)
F - Length of the fixed portion
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|