O'Reilly logo

Teradata Basics for Business Users by Tom Coffing, Leona Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 11 - 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required