Chapter 10

Join Indexes

“A wise man thinks it more advantageous not to join the battle than to win.”

– Francois de La Rochefoucauld

Table of Contents Chapter 10 – Join Indexes

Creating a Multi-Table Join Index

Visual of a Join Index

Outer Join Multi-Table Join Index

Visual of a Left Outer Join Index

Compressed Multi-Table Join Index

A Visual of a Compressed Multi-Table Join Index

Creating a Single-Table Join Index

Conceptual of a Single Table Join Index on an AMP

Compressed Single-Table Join Index

Aggregate Join Index

Sparse Join Index

A Global Multi-Table Join Index

Creating a Hash Index

Join Index Details

Creating a Multi-Table Join Index

  CREATE JOIN INDEX EMP_DEPT_IDX AS   SELECT Employee_No         ,E.Dept_No ...

Get Tera-Tom's 1000 page e-Book on Teradata now with O’Reilly online learning.

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