Changes to This Book - Teradata Database

Release

Description

Teradata Database 15.10

July 2015

UPDATE Statement

Edited description of correlation_name in “Target Table Options” on page 470 and corrected syntax in “Example 12: UPDATE With a Join” on page 489.

Teradata Database 15.10

June 2015

Aggregate Enhancements

SELECT Statement, DISTINCT, ALL, and NORMALIZE Operators, added “DISTINCT and GROUP BY” on page 64.

SELECT Statement, GROUP BY Clause, Usage Notes, added “GROUP BY and DISTINCT” on page 130

Column Partitioning with Primary AMP Index or Primary Index

“INSERT/INSERT … SELECT” on page 347, “Subquery Options” on page 350, “Inserting Into Row-Partitioned Tables” on page 356, “Inserting Into NoPI Tables” on page 358, “Rules for Using HASH BY or LOCAL ORDER BY to Insert Rows” on page 359, “Example: Using the LOCAL ORDER BY Option” on page 390, “Example: Using the RANDOM Option to Randomly Redistribute Data Blocks of Rows and Individual Rows Before Copying Them Locally” on page 390.

“MERGE” on page 405, “Rules for Using MERGE With Row‑Partitioned Tables” on page 434.

“UPDATE” on page 468, “Rules for Updating Partitioning Columns of a Row-Partitioned Table” on page 476, “Rules for Updating Column‑Partitioned Tables” on page 478, “Rules for Updating a Table with a Row-Partitioned Join Index” on page 476.

“UPDATE (Upsert Form)” on page 495, “UPDATE (Upsert Form) Insert Operations and Row-Partitioned Tables” on page 500, “UPDATE (Upsert Form) Update Operations and RPPI Tables” on page 501, “UPDATE (Upsert Form) and Join Indexes” on page 502.

Incremental Planning and Execution

EXPLAIN Request Modifier, Usage Notes, added “Dynamic Statistics Feedback for Remote Table Operators” on page 556.

Load Isolation

“INSERT/INSERT … SELECT” on page 347, “Isolated Loading Options” on page 348,

“DELETE” on page 321, “Isolated Loading Options” on page 322

“LOCKING Request Modifier” on page 392, “Lock Type” on page 393, “Using LOCKING ROW” on page 396.

“MERGE” on page 405, “Isolated Loading Options” on page 406, “MERGE Support for Load Isolated Tables” on page 445.

“UPDATE” on page 468, “Isolated Loading Options” on page 469, “UPDATE Support for Load Isolated Tables” on page 485.

“UPDATE (Upsert Form)” on page 495, “Isolated Loading Options” on page 495, “UPDATE (Upsert Form) Support for Load Isolated Tables” on page 506.

Object Naming

Removed references to 30-character limits for object names. Teradata Database supports object names up to 128 characters long in most cases. For information about naming database objects, see SQL Fundamentals.

Partition-Level Locking

SELECT, Examples, “Example 4: Partition Lock for a Row-Partitioned Table” on page 23.

DELETE, Usage Notes, “Locks and Concurrency” on page 324. Examples, “Example 6: Delete Rows with an Equality Constraint on a Partitioning Column” on page 333, “Example 7: Delete Rows with an Indirect Constraint on the Target Table Partitioning Column” on page 334.

INSERT/INSERT … SELECT, Usage Notes, “Locks and Concurrency” on page 352. Examples, “Example: Bulk Insert” on page 378, “Example: Insert Operation Using Single-Writer Lock” on page 379.

“LOCKING Request Modifier” on page 392, “Locking Object” on page 393, “LOCKING Request Modifier Use With DML Statements” on page 395, “Using LOCKING ROW” on page 396.

UPDATE, Usage Notes, “Locks and Concurrency” on page 473. Examples, “Example 4: Updating a Nonpartitioned Column with an Equality Constraint” on page 486.

UPDATE (Upsert Form), Usage Notes, “Locks and Concurrency” on page 500.

Table Operator USING Scalar Subquery

SELECT, “Table Operator” on page 92.