O'Reilly logo

Tera-Tom's 1000 page e-Book on Teradata by Tera-Tom 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 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 ...

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