15.10 - Changes To This Book - Teradata Database

Release

Description

Teradata Database 15.10 June 2015

Updated Chapter 2, “Query Rewrite and Optimization” with information about dynamic statistics collection based on IPE and optimizer cost profiles information for columnar primary AMP index and primary index. Updated Chapter 3, Join Planning and Optimization, with information about in-memory performance enhancements and in-memory hash joins. Updated existing EXPLAIN phrases and added new EXPLAIN phrases to Chapter 5, Interpreting the Output of the EXPLAIN Request Modifier,” for columnar primary AMP index and primary AMP and load isolation. Updated Chapter 6, “Query Capture Facility” with the following: BEGIN QUERY CAPTURE changes Relation table, ROWIDSPOOL value QuerySteps table, new StepAttributeType values QuerySteps table, new StepKind attribute values Information about columnar primary AMP index and primary index. Removed Chapter 8, Target Level Emulation. This information is currently located in Database Administration. Revised Chapter 9, “Locking and Transaction Processing,” and added information for: columnar primary AMP index and primary index load isolation partition-level locking