Archives of the TeradataForum
Message Posted: Thu, 21 Oct 2004 @ 18:39:35 GMT
<-- Anonymously Posted: Thursday, October 21, 2004 14:36 -->
Am I correct in assuming the following about PPIs :
1.You are only allowed 1 PPI per table
2. A PPI can only be comprised of one column/attribute
We have a table that requires a monthly purge based on date_a and a quarterly perge based on date_b.
Obviously, I would like to take full advantage of partitions for the deletes but I can only partition on one of the columns?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|