For more information, see:
- For more information about PPI properties and performance considerations or PPI considerations and capacity planning, see Teradata Vantage™ - Database Design, B035-1094.
- For more information about specifying a PPI for a table, see CREATE TABLE in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
- For more information about specifying a PPI for a join index, see CREATE JOIN INDEX in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
- For more information about modifying the partitioning of the primary index for a table, see ALTER TABLE in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
- For more information about the reconciliation of the partitioning based on newly resolved CURRENT_DATE and CURRENT_TIMESTAMP values, see ALTER TABLE TO CURRENT in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
- For more information on ADD_MONTHS, see Teradata Vantage™ Data Types and Literals, B035-1143.