Sybase IQ supports two different types of join hierarchies:
Linear joins
Star joins
You create ad hoc joins for both linear and star joins. Join indexes are designed for use with linear joins.
