Related Topics

Teradata Vantage™ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K
For more information, see:
  • For more information about PPI properties and performance considerations and PPI considerations and capacity planning, see Teradata Vantage™ - Database Design, B035-1094.
  • For more information about the specification of a PPI for a table, see CREATE TABLE in Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144.
  • For more information about the specification of 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 the modification of 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.