Sybase IQ uses foreign keys to define the relationships among columns that will be used in join indexes, and to optimize queries.
Note that key joins, which rely on foreign keys, are required for certain types of join indexes.
Sybase IQ does not support key join indexes based on multicolumn foreign keys.