If you know that certain tables in the same database will typically be joined in a consistent way, you may want to create a join index for those tables.
When you create a join index, Sybase IQ produces a new internal structure that relates table columns. It represents two or more tables, including the inner, left outer, and right outer rows.
