As with primary keys, use foreign keys to improve query join performance. This gives IQ one more piece of information on how tables are joined and the statistics behind those joins. IQ automatically creates an HG Index on the foreign key column, so no additional HG or LF index is necessary. A foreign key requires that a primary key exists on referenced table.