Chapter 41 - Explain

A rule to live by: I won't use anything I can't explain in five minutes.

- Phil Crosby

EXPLAIN Keywords

Locking Pseudo Table Serial lock on a symbolic table. Every table has one. Used to prevent deadlocks situations between users.
Locking table for Indicates that an ACCESS, READ, WRITE, or EXCLUSIVE lock has been placed on the table
Locking rows for <type> Indicates that an ACCESS, READ, or WRITE, lock is placed on rows read or written
Do an ABORT test Guarantees a transaction is not in progress for this user
All AMPs retrieve All AMPs are receiving the AMP steps and are involved in providing the answer set
By way of an all rows scan Rows are read sequentially on all AMPs
By way of primary index Rows are ...

Get Tera-Tom's 1000 Page e-Book on Teradata Architecture and SQL, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.