Types of Join Hierarchies

Sybase IQ supports two different types of join hierarchies.

You create ad hoc joins for both linear and star joins. Join indexes are designed for use with linear joins.

• Linear Joins
  You can think of a linear join as a tree with no branches.
• Star Joins
  You can picture a star join as a structure with many branches, in which each branch is directly related to one table in the middle.